Hi,
I have a string field, such as 20230520 and I would like to convert to a date field.
I tried to convert by parseDate and formatDate function, but is doesn´t work, I mean, it doesn´t error, but it doesn´t reconize as a date.
Any idea?
tks
July
Hi @July - Welcome to AWS QuickSight community and thanks for posting the question. You can change the data type of the field to yyyymmdd . Please see the below screenshot for the same.
Hope this will help you.
Regards - Sanjeeb
2 Likes
Thank you for your answer
I am going to try that and I let you know.
Best Regards
July.
2 Likes
Hello!
It´s working.
Tks a lot
2 Likes