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:
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.
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.
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.
