The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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
BenG
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

kane_glendenning
10 - Fireball
Hi,

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