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


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

Thanks in advance! :blush:

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.