Convert week (2023_01_02) to Jan 1 2023

[wonka1234]

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

[davidskaife]

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

[albert_alaluf]

Hello @wonka1234 ,

I did this in two steps. First I converted text to date, then with formula tool, I used datetimeformat. Please see attached.