Help

Formula taking date field and converting into month and year

Topic Labels: Formulas
635 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jessica_Scarrow
4 - Data Explorer
4 - Data Explorer

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")
)

Thank you! that worked perfectly!