Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax

How can we get date into CCMMYY formate means Century-Month-Year
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

     

    Try like

    quotient(year([date]),100) & format([Date],"MMYY")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

 

Try like

quotient(year([date]),100) & format([Date],"MMYY")