Formula taking date field and converting into month and year

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

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

Thank you! that worked perfectly!

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.