Date string and parsedate problem

My dataset has this [verified date] field, initial data type = integer,
I convert it to date type, it fails to populate at quicksight,

Seeking community member advice on this matter…

Then i convert it to string type, followed by parsedate function, it fail to populate too. Tried ifelse+parsedate function as proposed by another member, still fail to populate the data…

Seeking community member kind advice on this matter…

Hi @waisal01 - Welcome to AWS QuickSight community and thanks for posting the question. Can you please change the data type in dataset preparation page, by selecting the column and change the type to date and give the format. Validate the data in data set page and then used for your analysis.

Regards - Sanjeeb

1 Like

Hi! Sanjeeb,
Tried as per you suggestion format MM-DD-YYYY. Same problem & SQL error message.

Hi @waisal01 - It looks like all the records are not in the same format. Can you please raise a ticket to AWS Customer support team to help you on this and provide the request ID from your screenshot. To raise a request, please follow the link - Creating support cases and case management - AWS Support.

Regards - Sanjeeb