Forum Discussion
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.
Hmmm... you didn't get my point. The lower-case "mmm" in the format string is the key.
4 Replies
- CNENFRNL
Community Champion
- jdbuchanan71
Super 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
Community Champion
Hmmm... you didn't get my point. The lower-case "mmm" in the format string is the key.