YYYY/MM/DD to MM/DD

[MonaAlmutairi]

Hi everyone,

I would like to convert some date in the format YYYY/MM/DD to be only month and days -> MM/DD

and what about if I wanted another format such as 01-Jan?

I appreciate your support!

Thank you.

[Yoshiro_Fujimori · Accepted solution]

Hi @MonaAlmutairi ,

First convert the string "YYYY/MM/DD" to Date type "YYYY-MM-DD" with DateTimeParse function

and then you can use DateTimeFormat function to format it as you like.

Check this help page. https://help.alteryx.com/20223/designer/datetime-functions

Sample Formula

DateFormat = DateTimeParse([Date],"%Y/%m/%d")

MM/DD = DateTimeFormat([DateFormat],"%m/%d")

dd-mmm = DateTimeFormat([DateFormat],"%d-%b")

Output

Good luck.

[MonaAlmutairi]

@Yoshiro_Fujimori Thank you!! very comprehensive explanation!