Forum Discussion

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago
Solved

Problem with mmm in custom format on date field

I am trying to create a chart friendly Month Year field formatted as mmm-yyyy (Feb-2022) but the custom formatting field is not accepting the mmm-yyyy as a valid string.  Has anyone else run into this?

 

Month Year column is data type Date

But when I go to the model view to apply the custom format it is not taking the mmm as short month.

I input mmm-yyyy it converts it to MMM-2019

I am working on Version: 2.100.1401.0 64-bit (December 2021) that I just downloaded from the Microsoft site.

https://www.microsoft.com/en-us/download/details.aspx?id=58494

I have attached my sample file if anyone wants to look with it.

 

 

  • CNENFRNL's avatar
    CNENFRNL
    4 years ago

    Hmmm... you didn't get my point. The lower-case "mmm" in the format string is the key.

     

4 Replies

    • jdbuchanan71's avatar
      jdbuchanan71
      Icon for Super User rankSuper User

      Thank you CNENFRNL 

      When you use FORMAT you get a text field that won't sort in chart axis correctly.  I wasn't looking for an alternative, I was looking for feedback if other users are seeing the same problem.

      • CNENFRNL's avatar
        CNENFRNL
        Icon for Community Champion rankCommunity Champion

        Hmmm... you didn't get my point. The lower-case "mmm" in the format string is the key.