Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula taking date field and converting into month and year

Topic Labels: Formulas
150 2
cancel
Showing results for 
Search instead for 
Did you mean: 

i’m looking for a way to creat a formula that takesmy “date created field” date and translates it to the following:

January = 1
February = 2
March = 3
April = 4
May = 5
June = 6
July = 7
August = 8
September = 9
October = O
November = N
December = D

and then the Year with just the 2 digits.

Examples:
October 12th, 2003 = O03
September 3rd, 2014 = 914
January 27th 2018 = 118
February 19th 2021 = 221

2 Replies 2

Hi @Jessica_Scarrow,

This should do it:

IF(
  {Date Created},
  SWITCH(
    MONTH({Date Created}),
    10, "O",
    11, "N",
    12, "D",
    MONTH({Date Created})
  ) &
  DATETIME_FORMAT({Date Created}, "YY")
)