hi all,
i have created in dataset a new field:
formatDate({data_comp},“YYYY”)
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! 
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.
Thanks!
1 Like
