Quicksight date format issue

Question

So I have a set of business data that I would like to visualize in Quicksight. And some of the date formats are like - 0001-01-01 00:00:00 . Which is not being accepted by Quicksight. This set of date format is very important for the business and can't be excluded. Is there any way to display this? Whenever this format comes, no data is being loaded in Quicksight

Answer

Hi Naveen,
You can manually customize the date format like yyyy-mm-d HH:mm:ss following the steps on this link [Format a date field](https://docs.aws.amazon.com/quicksight/latest/user/format-a-date-field.html)

When you choose the Custom in the Date and Time sections, expand the Custom section and specify the format pattern that you want, using the format pattern syntax specified in Moment.js Display Format in the [Moment.js Display Format ](https://momentjs.com/docs/#/displaying/) documentation.

I hope it helps,

Answer

I would reevaluate using that date and using something else.

Quicksight date format issue

Relevant content