Hello,
How do you format the following dates:
A. from 01-DEC-2022 to 12/01/2022
B. from 12/25/22 09:09:40 to 12/25/2022
Original date formats come from an excel file.
Thank you!
@Zenn6420
Please find the expected output.
What is the expected output please.
Hi!
Sorry my question was sort of confusing. Please refer below
date/time conversion tool can help you with both of these examples.
1. you can convert this in formula with: datetimeparse([Field],"%d-%b-$Y")
2. You can convert this in formula with datetimeparse([Field],"%d/%m/%y %H:%M:%S")
Once you have turned them into dates you can extract the data you want with:
datetimeformat([field],"%m/%d/%Y") - or keep them as Y-m-d for standard Alteryx date time calculations...
Hi @Zenn6420
Thanks for your response. I'm really having a hard time using DateTime functions in Alteryx, can you please upload a sample workflow?
Here is my excel file.
Thank you so much!
@Zenn6420 Two ways of doing this 1. with formula tool 2 with the datetime tool
Hello, thank you so much!
Hey, thank you so much!
