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 #?

Image Sensor
I want to return the abbreviate month such as FEB when the month # is 2.  How do I EASILY do that?
Labels (1)
0 Kudos
1 Reply
Highlighted
Image Sensor
Found my answer, here is the formula:  

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

This provides the previous month's abbreviataion

0 Kudos