Forum Discussion
Date Conversion
I have a date format like this Tuesday,25 March,2025 and wanted to convert like YrMth ex: 2025Mar MthYr ex: Mar2015 I tried various options in the formating but couldn't find the way what...
Hi Thimma,
Have you ttied SabineOussi's solution? I have tested it which works fine. As SabineOussi said, you need to make sure the column is a date format. If it's a string data type, you need to get the year and month from the string manually. We can use Search function, Left and Right function to achieve this requirement.
https://msdn.microsoft.com/en-us/library/ee634235.aspx
https://msdn.microsoft.com/en-us/library/ee634781.aspx
Regards,
Charlie Liao