date

[bh1789]

if I have the following:

Message Date

2022-01-01 (Date Type)

How would I output the following:

Report Month

Jan 2022

Thank you!

[Felipe_Ribeir0]

Hi @bh1789 

Use this formula: 

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

[gautiergodard]

Hey @bh1789

Here you go for one way to do this! 

[IraWatt]

Hey @bh1789,

You can use the date parse and date format functions to achieve this:

DateTimeFormat(
DateTimeParse([Message Date],"%y-%m-%d")
,"%b %y")

Date time parse converts your text data to a date data type and then the format converts it back to text in your given format.

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[binuacs · Accepted solution]

@bh1789 One way of doing this

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

[bh1789]

Thank you!