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 thi...
Need Help
  • 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.

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

 

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

    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
      4 years ago

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

       

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

        Ah, gotcha.  Yes, doing the string in the format field of the table view seems to do the trick.  Thank you!