Hello, when I use the custom format ‘Yw’ on a date field on the field well it works and presents the date in form of ‘201911’ (as intended) but when I use the same format type ‘Yw’ in the function formatDate() in a calculated field (i.e. formatDate({DateField},‘Yw’) ) it doesn’t give any error when creating and saving it but it gives me error when used in a visual. Does anyone know why?
Hello @anasia,
Custom date format and formatDate use different formats.
QuickSight does not support yet extracting the week, if you are looking for something like that, this community post has a formula to return the week from a date.
Hope this helps!
Kind regards,
Andres.