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
@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
@shahnawaz_khan Before you receive a solution can you show us what you have tried so far?
@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
