Hi all!
I am preparing a dataset for my analysis and the format of date is like: 2021-10-20T00:00:00.000Z
How to change the format into 2021-10-20 by creating a calculated field?
Thanks in advance!
Fengjing
Hi all!
I am preparing a dataset for my analysis and the format of date is like: 2021-10-20T00:00:00.000Z
How to change the format into 2021-10-20 by creating a calculated field?
Thanks in advance!
Fengjing
Have you tried formatDate like formatDate({coachingcolsetimestamputc}, 'YYYY-MM-dd')
? Reference document for calculated functions: formatDate - Amazon QuickSight
Hey, thanks for answering. I tried this and it gives me a new string format column, but I want to edit the current date column format to yyyy-MM-dd.
Hi @fengjing,
You can edit the date format of your existing field in your dataset by following the below steps and then deleting the outlined section in the second screenshot below.