Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert week (2023_01_02) to Jan 1 2023

wonka1234
10 - Fireball

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

2 REPLIES 2
DavidSkaife
13 - Pulsar

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

 

DavidSkaife_0-1685543754044.png

 

albert_alaluf
9 - Comet

Hello @wonka1234 ,

 

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

 

Labels