Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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...
Need Help
SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

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.