Alteryx Designer Desktop Discussions

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

Date Time

Gamaliel
10 - Fireball

How can I convert 2020-01-31 to January 2020?

 

Thank you.

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Gamaliel 

 

Use formula

 

DateTimeFormat([Field1],"%B %Y")

 

%B is full month name

%Y is full Year

 

https://help.alteryx.com/20212/designer/datetime-functions

 

Hope this helps 🙂

Gamaliel
10 - Fireball

Perfect !

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Gamaliel 

Labels