Date to show as MMM YY
I have a due month formula field that needs to be sorted and reported by date and not by text. I'm trying to have it show as MMMYY (JAN24, FEB24, etc) since it's just a due month and not a specific d...
Forum Discussion
Your formula is fine - Month is just special since it's also the name of a formula to get the month as you're doing. Just change the variable name from var text month to anything else, something like var text monthT = ... and you'll be fine.