Converting numerical dates to month


#1

This is pretty simple problem, but I can’t figure out how to get this to work on Airtable. What I want to do is program a column with a function that converts information from a date column to another column in Month word form. Using Month () I can get it to work in Numerical form (i.e ‘12/14/89’ becomes ‘12’) But I can’t find a way to make it say ‘December’.


#2

Use DATETIME_FORMAT(Your_Date, ‘MMMM’)

See Supported format specifiers for DATETIME_FORMAT.


#3

You’re looking for DATETIME_FORMAT() with the appropriate format specifier. For instance

DATETIME_FORMAT({Date},'MMMM')

will get you the month name.

Take a look at the specifier list; you can get it to do all sorts of things…


#4

Yes! Thanks so much!