cancel
Showing results for 
Search instead for 
Did you mean: 

How do I get an abbreviate month verbiage to show up just based on month #?

How do I get an abbreviate month verbiage to show up just based on month #?

I want to return the abbreviate month such as FEB when the month # is 2.  How do I EASILY do that?
Labels (1)
1 Reply

Found my answer, here is the formula:  

Upper(DATEFORMAT(DATEADD(NOW(),-1,"months"),"MMM"))

This provides the previous month's abbreviataion