Help Needed: SPICE Failing Due to Default Date Value in Quick Sight

We’re having an issue with our dataset in Quick Sight. For the Date of Birth (DOB) field, we’ve set it up so that if no DOB is provided, a default date of “1000-01-01 00:00:00” is automatically assigned. However, this is causing errors when using SPICE to process the dataset.

Can anyone suggest a different default value or format that would be compatible with Quick Sight and prevent these errors?

For your reference i have attached a screenshot for it.

It appears Quick Sight supports dates fro Jan, 1, 1400. So try that and see if that works

Hi @Abhishek_24,
It’s been awhile since we last heard from you. 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 case.

Thank you!

Hi @Abhishek_24,
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!