Formatdate year

hi all,
i have created in dataset a new field:
but the reload data SPICE doesn’t work! i have an error.
i don’t know why!

thanks a lot.

Hi, @Fiorini_Massimo. Welcome to the QuickSight Community, and thanks so much for posting your question! :slight_smile:

Due to the US holiday, our team will review this question on Monday. In the meantime, we encourage anyone form the Community to reply.

Hi @Fiorini_Massimo, can you make sure that the date you’re trying to format is set as a Date datatype?
For example, I created a dataset with US date format and UK date format. QuickSight recognised the US date as a date, but the UK date as a string. When I applied the formatDate function on the US date is was fine, but on the UK date it showed an error. To resolve, I converted the UK date field to a Date datatype.
Hope that helps, please mark as a solution if this works for you.

1 Like

this is the problem after i formatted a day in
formatdate ([field], ‘YYYY’)