Home Data Prep Q&A

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

Visit the official Paxata Documentation portal for all of your doc needs.

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?

Answers

  • Found my answer, here is the formula:  

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

    This provides the previous month's abbreviataion

Sign In or Register to comment.