Format datetime field in 'dd-MMM-yyyy hh:mm:ss a'

Question & Answer
, , ,
7

HEllo Rohit,

To convert the ISO 8601 date format (example - > 2024-08-15T03:00:59.00Z) to 12-hour format in Amazon QuickSight, you can use the parseDate() function in a calculated field. See here for referecne

For timestamps with ‘T’ and ‘Z’ characters like yours, you need to handle these special characters by enclosing them in single apostrophes.
You can create a calculated field using this formula:

parseDate({YourDateField}, 'yyyy-MM-dd\'T\'HH:mm:ss.SS\'Z\'')

After parsing the date correctly, you can format it to display in 12-hour format using the formatDate() function with the appropriate tokens. Reference

To get 12-hour format, use the ‘h’ or ‘hh’ token for hours and ‘a’ for am/pm indicator.

For example:

formatDate(parseDate({YourDateField}, 'yyyy-MM-dd\'T\'HH:mm:ss.SS\'Z\''), 'yyyy-MM-dd hh:mm:ss a')

Hope this helps.
Cheers,
Deep