Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Date automatically updating

Batchoisai
6 - Meteoroid

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!

2 REPLIES 2
brandon_bunney
8 - Asteroid

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
6 - Meteoroid

Thank you so much!

This is exactly what I was looking for!

Labels