How to change the format of date when editing the dateset

Q&A
, , , ,
1

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

2

Have you tried formatDate like formatDate({coachingcolsetimestamputc}, 'YYYY-MM-dd')? Reference document for calculated functions: formatDate - Amazon QuickSight

4

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.

5

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.
image

image