Date automatically updating

[Batchoisai]

Hello!

So I'm bringing in a .xlsx file with participant information and one of the dates automatically updated to a different date.

The date that was on the file was 2/1/1900 and when I opened it up on Alteryx using 'Input Data' tool, it changed it to 1/31/1900.

This only happens for this date and not the countless others, but this is also the only 1900 date on the file.

Does anyone know why this is happening?

Thanks in advance!

[brandon_bunney · Accepted solution]

Here's a link to a post from Ned that should help

Essentially- Excel is known to not handle dates prior to 3/1/1900 effectively, so it makes sense that your only 1900 date in the file would have this issue. 

[Batchoisai]

Thank you so much!

This is exactly what I was looking for!