Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DateFrormat

Hi All,

 

I have a date column for 3 Years in the format 01/01/2019, need to display the month in short and the respective financial Year.

 

Example:  Current Format: 01/01/2019

              Required Format : Jan-19

 

Thanks,

chandra

  

 

Need Help
  • judspud's avatar
    judspud
    7 years ago

    Hi Anonymous 

     

    Are your financial years simply the year of the date?

     

    if so you can use the following formula;

     

    Month Year = Format('Calendar'[Date],"MMM YY")

     

    Where Calendar is the table name and Date is the column name

     

    Hope this helps

     

    Thanks,

    George

2 Replies

  • judspud's avatar
    judspud
    Solution Supplier
    7 years ago

    Hi Anonymous 

     

    Are your financial years simply the year of the date?

     

    if so you can use the following formula;

     

    Month Year = Format('Calendar'[Date],"MMM YY")

     

    Where Calendar is the table name and Date is the column name

     

    Hope this helps

     

    Thanks,

    George