Quicksight data parse error for invalid dates

[Xclipse]

Hi @pranav91

Welcome to the community!

Please refer the below Quick Sight documentation and community post this might be helpful for you.

Quicksight can not parse Date from dataset

Hi Community! I am a new user of Quicksight. I use it to visualize my dynamoDB data with Athena Connector. I have LatestDate field which is initially a string and 99.99% of rows have format yyyy-MM-dd'T'HH:mm:ss.SSSSSS+SS:SS. And sometimes there are rows that have yyyy-MM-dd'T'HH:mm:ss+SS:SS format. I don’t mind skipping them, so I just changed the data type for LatestDate to Date with yyyy-MM-dd'T'HH:mm:ss.SSSSSS+SS:SS. And as far as I understand Quicksight will drop invalid rows. But then …

Supported date formats - Amazon QuickSight