Skip to main content

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

)


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!


Reply