Date Formatting in Dataset doesn't work as expected


I am trying to format a column in dataset to date format, using a supported format by AWS.
However, still getting an error.

Hi @Annab,

It seems QuickSight is not recognizing the format. If you change the format to ‘yyyy-MM-dd HH:mm:ss.SSS’, it works. Can you convert it?

Let’s say your Source Data field is OrderDate. You can use a calculated field to covert it:

parseDate(replace(substring({ OrderDate},1,((locate({ OrderDate},‘+’))-1)), ‘T’, ’ '),‘yyyy-MM-dd HH:mm:ss.SSS’)

Let us know if this works. Thanks!

1 Like