I require date in below format. Is it possible doing in Alteryx formula?
Format required: 2024-JAN
Current format: 202401
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'))
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.
@DataNath This formula is not giving any result
Wohho, thank you. I forgot to convert it to string initially. @DataNath
