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")

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous 

     

    Try like

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