MM yy

[Kinetic_analytics]

Hello:

How can I make formula in formula tool? Is there shortcut to remember the Date time format conversion in Alteryx? 

Aug 2022

Sep 2022

Oct 2022

Appreciate your help.

Thaks

[DataNath · Accepted solution]

Hey @Kinetic_analytics if I'm understanding your question right, then you can save expressions and then simply load them again in future:

[Felipe_Ribeir0 · Accepted solution]

Hi @Kinetic_analytics 

Use this formula

DateTimeFormat([Date], '%b %Y')

If you want to know exactly how to do it, the best is to check this documentation. It helps a lot.

https://help.alteryx.com/20221/designer/datetime-functions#:~:text=Alteryx%20uses%20the%20ISO%20form....

[Kinetic_analytics]

@DataNath Hey Man! do you know how cool you are! you are a Alteryx superman! I have learned a lot from you! If you stay in the USA, Happy thanksgiving. I am grateful to have you my friend! What a joy! 

[Kinetic_analytics]

Noice! Thank you @Felipe_Ribeir0 . :)