formatDate() gives me an error about unsupported format

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,