Extracting date, month (in numeric) , year in a separate column

[sriniprad08]

Hi Team,

Hope you are well.

I would like to extract month, year , date in a separate column.  

"2023-09-01 00:00:00"

Thanks for the help.

Sri

[gawa · Accepted solution]

hi @sriniprad08 

You can use DateTimeFormat function in Formula tool.

See the manual for the definition of the specifiers.

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#idm45436756854512

[sriniprad08]

Thank you @gawa Appreciate that.