We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi All,
I am looking to convert a string field that is actually a date to a specific format:
Managed to split the time, however the month is "OCT" instead of "10"
Thanks in advance for the help.
Input
| DATE_REC |
| 25/OCT/21 12:00:00 AM |
| 26/OCT/21 12:00:00 AM |
| 27/OCT/21 12:00:00 AM |
| 28/OCT/21 12:00:00 AM |
| 29/OCT/21 12:00:00 AM |
| 30/OCT/21 12:00:00 AM |
| 01/NOV/21 12:00:00 AM |
| 02/NOV/21 12:00:00 AM |
| 03/NOV/21 12:00:00 AM |
Output
| DATE_REC |
| 25/10/2021 |
| 26/10/2021 |
| 27/10/2021 |
| 28/10/2021 |
| 29/10/2021 |
| 30/10/2021 |
| 1/11/2021 |
| 2/11/2021 |
| 3/11/2021 |
Solved! Go to Solution.
all good, solution found
