Community GitHub
Support Portal
DataRobot University
DataRobot.com
English
日本語
Sign Up
Sign In
Browse
Ask
Data Prep (Paxata)
Data Prep Q&A
Data Prep Fundamentals
Admin Corner
Excel Transition Guide
Advanced Data Prep Techniques
Product Release Notes
Platform
AI Platform Trial
Watch
Sessions
Read
Resources
Blog
Eureqa Academic
About Community
Community News
Community Resources
All Community
This category
This board
Knowledge base
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Join the upcoming webinar: See DataRobot in Action
Community
:
Ask
:
Data Prep (Paxata)
:
Data Prep Q&A
:
How do I get an abbreviate month verbiage to show ...
Options
Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Mute
Printer Friendly Page
How do I get an abbreviate month verbiage to show up just based on month #?
willm125
Image Sensor
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Printer Friendly Page
Email to a Friend
Report Inappropriate Content
02-17-2020
10:00 PM
I want to return the abbreviate month such as FEB when the month # is 2. How do I EASILY do that?
Labels
(1)
Labels
Labels:
Data Prep
0
Kudos
Share
Reply
All forum topics
Previous Topic
Next Topic
1 Reply
willm125
Image Sensor
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Printer Friendly Page
Email to a Friend
Report Inappropriate Content
02-17-2020
10:25 PM
Found my answer, here is the formula:
Upper(DATEFORMAT(DATEADD(NOW(),-1,"months"),"MMM"))
This provides the previous month's abbreviataion
0
Kudos
Share
Reply