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
