Date Format

[Kristie_Pires]

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!

[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-dat...

[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. 

HTH,

Ira

[Sebastiaandb · Accepted solution]

@Kristie_Pires ,

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

Greetings,

Seb

[Kristie_Pires]

Thank you all for helping me understand why it was happening in the first place :) 

Thanks @Sebastiaandb - your formula solved the issue! 

[IraWatt]

No worries @Kristie_Pires ! Glad it helped :)

[sireeshagandam]

Good