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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.