Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago

Add short month to DATE query syntax.

I found the following on Chris Webb's blog and it works great, however, I need to include the Short month format ie. Jan, Feb, Mar, etc. .  What do I need to modify, or can you recommend a different ...
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

If you don't need long month name, just delete one of the M from the line that starts 

 

InsertMonthName.

 

ie swap "MMMM" with "MMM"

 

 If you need both, then

1 duplicate this same line

2 rename the second of the two lines InsertMonthShort

3 on the second line, change "MonthName" to "MonthShort"

4 on the second line, change InsertDayInt to InsertMonthName

5 on the line starting with InsertCalendarMonth, replace InsertMonthName with InsertMonthShort