# Quicksight data parse error for invalid dates **URL:** \ **Category:** Q&A\ **Tags:** error, dataset, Business-Intelligence-Engineer, formatting, quick-sight\ **Created:** [August 8, 2024, 1:17pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630 "2024-08-08T13:17:13Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![pranav91](https://avatars.discourse-cdn.com/v4/letter/p/85e7bf/32.png) [@pranav91](https://community.amazonquick.com/u/pranav91)\ **Post date:** [August 8, 2024, 1:17pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/1 "2024-08-08T13:17:14Z")
I am facing an error with my date columns when visualizing the data in quicksight. It gives me the following error: “ **Amazon Quicksight cannot parse the data because it contains invalid dates or invalid numbers. Make sure your data contains only supported numbers and date formats.** ” This error does not occur with all date columns. Like for example for one of my date columns “Last Updated Date” it displays the values properly however for another date column “first response date” it gives me the above error. While formatting the above two date columns, when I try to validate the above two date columns in the quicksight dataset, it shows that it is validated and does not report any error. One reason which I think could be that “Last Updated date” always has a date value mentioned but the “first response date” sometimes contains an empty value. Could this be the case? How do I fix this issue to ignore the empty values and simply display as an empty field. Some images for your reference are attached below: ![Screenshot 2024-08-08 at 15.09.34](https://d1wl4jav5dp96l.cloudfront.net/original/3X/4/e/4ea628cfd97cdc7369c94d1631b0d75474a53117.png) ---
**Author:** ![pranav91](https://avatars.discourse-cdn.com/v4/letter/p/85e7bf/32.png) [@pranav91](https://community.amazonquick.com/u/pranav91)\ **Post date:** [August 8, 2024, 1:22pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/2 "2024-08-08T13:22:39Z")
![Screenshot 2024-08-08 at 15.18.17](https://d1wl4jav5dp96l.cloudfront.net/original/3X/9/0/90222e1e457a9dbf96aaff8177129c71cc7ec27c.png) cc: @tsh1089 ---
**Author:** ![pranav91](https://avatars.discourse-cdn.com/v4/letter/p/85e7bf/32.png) [@pranav91](https://community.amazonquick.com/u/pranav91)\ **Post date:** [August 8, 2024, 2:01pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/3 "2024-08-08T14:01:46Z")
![Screenshot 2024-08-08 at 16.01.32](https://d1wl4jav5dp96l.cloudfront.net/original/3X/4/1/414932c9097a92c21eb54aa2e0bf5882e1490627.png) ---
**Author:** ![pranav91](https://avatars.discourse-cdn.com/v4/letter/p/85e7bf/32.png) [@pranav91](https://community.amazonquick.com/u/pranav91)\ **Post date:** [August 8, 2024, 2:07pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/4 "2024-08-08T14:07:05Z")
![Screenshot 2024-08-08 at 16.02.10](https://d1wl4jav5dp96l.cloudfront.net/original/3X/8/0/80c89deab85b23c0e3cdc89ee5e05e86bbfe27a8.png) ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [August 10, 2024, 6:00am UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/5 "2024-08-10T06:00:43Z")
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](https://community.amazonquick.com/t/quicksight-can-not-parse-date-from-dataset/10426): > > 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](https://docs.aws.amazon.com/quicksight/latest/user/supported-date-formats.html)** > > Amazon QuickSight supports the date and time formats described in this section. Before you add data to Amazon QuickSight, check if your date format is compatible. If you need to use an unsupported format, see . ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [August 19, 2024, 3:13am UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/6 "2024-08-19T03:13:37Z")
Hi @pranav91 It’s been a while since we last heard from you, did you have any additional or follow up questions regarding your initial topic? Were you able to try out the last approach that was shared? If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution to close out the topic. Thank you! ---
**Author:** ![tsh1089](https://avatars.discourse-cdn.com/v4/letter/t/eada6e/32.png) [@tsh1089](https://community.amazonquick.com/u/tsh1089)\ **Post date:** [August 23, 2024, 7:55pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/7 "2024-08-23T19:55:45Z")
Hi @Xclipse We will check and update on this next week as Pranav is currently OOO. Regards, Tushar ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [August 29, 2024, 6:42pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/8 "2024-08-29T18:42:20Z")
Hi @pranav91 @tsh1089 Did you have any additional questions regarding your initial topic? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [September 13, 2024, 8:32pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/9 "2024-09-13T20:32:38Z")
Hi @pranav91 & @tsh1089, Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [September 13, 2024, 8:33pm UTC](https://community.amazonquick.com/t/quicksight-data-parse-error-for-invalid-dates/33630/10 "2024-09-13T20:33:14Z")