Date Format

Hi there,

I have an excel file where all the dates are formatted as MM/dd/yyyy

ex: end_date >>> 5/10/2022

So I have the DateTime tool convert these strings to dates which requires the incoming string format to stay the same.

However, some days these string fields have this format yyyy-MM-dd in Alteryx (not in excel) before hitting the DateTime tool. This means I have to manually fix the formulas for the workflow to give me the data I want to see.

Has anybody encountered a similar situation? I am not sure how to prevent Alteryx from changing the format.

Thank you!

Date Time

Help

Accepted answers

Sebastiaandb

@Kristie_Pires ,

Mmmm interesting! Why not make a formula that can handle the cases that occur?

Greetings,

Seb

dategenerator.yxmd

All comments

Luke_C

Hi @Kristie_Pires

Take a look at this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-does-Alteryx-quot-read-in-quot-dates-and-assign-date-data/td-p/80853

IraWatt

Hey @Kristie_Pires,

This is happens when the data in excel is defined as text or dates:

results in your issue:

Cells defined as dates in excel will be converted to Alteryx date format, cells defined as text wont. To avoid this you can change your file type to CSV this will force everything to come in as text.