How to change the format of date when editing the dateset

Hi all!

I am preparing a dataset for my analysis and the format of date is like: 2021-10-20T00:00:00.000Z

image

How to change the format into 2021-10-20 by creating a calculated field?

Thanks in advance! :blush:
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.