Date Conversion

[Anonymous]

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 I wanted as mentioned above.

Thanks,

[v-caliao-msft]

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

[SabineOussi]

Try creating theses columns

MthYr = FORMAT(Table[Date], "MMMYYYY")

YrMth = FORMAT(Table[Date], "YYYYMMM")

Where MMM refers to the first three letters of the month and YYYY correspond to the full year.

But first, make sure your Date column is of type Date or Date/Time.