Support for the 1900 date format

[kane_glendenning]

It would be good if in the date format option for the Parse tools etc, if there was an option for the 1900 date format used sometimes in Excel/SQL. This is where the date is represented as the number of days from 1/1/1900. If this support was added then the same support for time be represented as a decimal {0,1} would be good as well. Besides this being a nice addition to the software, it would also help with any workarounds stemming from an excel file being open when imported causing the format to come through differently. (Currently if the Excel input file is open in the background which can happen on network available files, the time comes in to Alteryx asa decimal and the date appears as 1900 format).

[BenG]

Hi Kane,

With the latest 9.5 release, we have provided a new xlsx reader that handles these 1900 date formats on input.  If you are seeing issues with this, please contact Client Services as we will need to investigate and try to resolve the issue.

Thanks,

Ben

[kane_glendenning]

Hi,

After talking to Mike Bryan at Inspire, I can clarify this to exposing this conversion in the formula tool.