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.
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
Thank you for your answer
I am going to try that and I let you know.
Tks a lot