how to convert date & time in Months

[shahnawaz_khan]

How to convert below date time in months (Ex. Mon-yy)

02-10-2023 01:22

2023-10-04 03:22:33

28-12-2023 11:11

[Qiu]

@shahnawaz_khan 
Refer to this weekly challenge, and you can do it. 😁

https://community.alteryx.com/t5/Weekly-Challenges/Challenge-414-Mastering-Date-Formats/td-p/1242461

[Deano478]

@shahnawaz_khan Before you receive a solution can you show us what you have tried so far?

[rzdodson]

@shahnawaz_khan here is one approach for you. Drop this in a Formula tool to get it converted over.

If Substring([Old Date],2,1)='-' then

Substring([Old Date],6,4)+'-'+Substring([Old Date],3,2)+'-'+Substring([Old Date],0,2)+' ' +Right([Old Date], 5)+":00"

else [Old Date]

endif