if I have the following:
Message Date
2022-01-01 (Date Type)
How would I output the following:
Report Month
Jan 2022
Thank you!
Solved! Go to Solution.
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
Thank you!