formatDate() gives me an error about unsupported format

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,