In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date Time

Gamaliel
10 - Fireball
‎07-09-2021 12:43 AM

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

 

Thank you.

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova
‎07-09-2021 12:45 AM

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 🙂

year.yxmd
Reply
0 Likes
Gamaliel
10 - Fireball
‎07-09-2021 12:49 AM

Perfect !

Reply
atcodedog05
22 - Nova
22 - Nova
‎07-09-2021 12:51 AM

Happy to help 🙂 @Gamaliel 

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All