Date format required : 2025-NOV

[Meghnagupta]

I require date in below format. Is it possible doing in Alteryx formula?

Format required: 2024-JAN

Current format: 202401

[DataNath]

Hey @Meghnagupta, you can use the following expression in a Formula tool:

Uppercase(DateTimeFormat(DateTimeParse([Input],'%Y%m'), '%Y-%b'))

Just replace [Input] with your actual data field.

[Meghnagupta]

@DataNath  This formula is not giving any result

[DataNath · Accepted solution]

Can you tell me why? Any particular error you're getting? If your incoming data i.e. in format 202401 is in numeric format, you'll need to convert it to a string first. For that you can use:

Uppercase(DateTimeFormat(DateTimeParse(ToString([Input]),'%Y%m'), '%Y-%b'))

[Meghnagupta]

Wohho, thank you. I forgot to convert it to string initially. @DataNath