I am trying to use date time tool to convert my weekly dates to week actual names but getting null.
Ie I want to convert or create a new column from this:
2023_01_02 |
2023_01_09 |
2023_01_16 |
2023_01_23 |
to
Jan 2 2023
Jan 9 2023
Jan 16 2023
Jan 23 2023
Hi @wonka1234
Try this formula in a Formula tool:
DateTimeFormat(DateTimeParse([Datefield],'%Y_%m_%d'),'%b %d %Y')
DateTimeParse converts your incoming date into ISO format, then DateTimeFormat converts it from ISO to the required format
Hello @wonka1234 ,
I did this in two steps. First I converted text to date, then with formula tool, I used datetimeformat. Please see attached.