community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Support for the 1900 date format

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).
3 Comments
Alteryx Alumni (Retired)

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

Alteryx Certified Partner
Hi,

After talking to Mike Bryan at Inspire, I can clarify this to exposing this conversion in the formula tool. 
Alteryx
Alteryx
Status changed to: Implemented