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

 

Thanks,

Need Help

2 Replies

  • SabineOussi's avatar
    SabineOussi
    Skilled 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.

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    10 years ago

    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