Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Using Formula MONTH and DATETIME_FORMAT

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

My formula is MONTH({Trial Date})-1
I want that to then return a month name instead of a number.
I’ve been trying to figure out the DATETIME_FORMAT to do it, but I cant get it.

2 Replies 2

To replace a month number with a month name, use a SWITCH statement as demonstrated below.

How it Works

SWITCH(
    some logic that returns a value,
    if the value is this,
    return this,
    if it's this,
    return this,
    etc.
)

MONTH({Trial Date})-1
I think you’re trying to describe ‘the month before the trial date?’ If so, run this:

SWITCH(MONTH({Trial Date})-1,0,"January",1,"February",2,"March",3,"April",4,"May",5,"June",6,"July",7,"August",8,"September",9,"October",10,"November",11,"December")

THANK YOU! This worked perfectly! I’m not familiar with SWITCH.

Thank you for your help on this!