Date returning different number

Does anyone know what would cause this to happen:

We have financial start and end dates for contracts:

Excel Project Model.png

But when I run it through my workflow it gives me this:

Alteryx Output.png

Alteryx Metadata.png

this file is a tad different because it says '=H26 for the Financial Contract Start Date, and not just a hard date. But why did it return the date as 1905-07-05 for the start date, but returned the right end date?

I can fix it by making the date a hard coded date in Excel, but I want to understand why it is doing it in this case, and not another.

Thanks,

Rebecca

Topic of Interest

Accepted answers

danilang

Hi @RCurry1230

Your new dates (2013-06-17) are being interpreted as excel internal date types (double) on input by alteryx. The number is truncated to 2013 which converts to 1905-07-05 according to Excel date math. 1899-12-30 is the start date for the Excel date calculations

I've only ever seen this in .xls files before when the Jet engine is used to read data.

What's interesting is that the financial contract end date is converted properly even though it's a formula too. If you look at the Contract start and end date, the source for the Financial values, the start is entered as "2013-06-17" but the end is entered as 06/13/2025. It looks like alteryx is able to convert the dates that have "/" but not "-". The first value in cell H2 is formatted as "03/17/2019" Maybe this is used as a template for column.