How to convert string format YYYYMMdd to date

Question & Answer
, ,
1

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

2

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.

image
image1282×715 112 KB

Hope this will help you.

Regards - Sanjeeb

2 Likes
3

Thank you for your answer
I am going to try that and I let you know.

Best Regards
July.

2 Likes
4

Hello!

It´s working.
Tks a lot

2 Likes