Help

Re: Converting numerical dates to month

2196 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Cardoza
5 - Automation Enthusiast
5 - Automation Enthusiast

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’.

5 Replies 5
Christoff
7 - App Architect
7 - App Architect

Use DATETIME_FORMAT(Your_Date, ‘MMMM’)

See Supported format specifiers for DATETIME_FORMAT.

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…

Yes! Thanks so much!

Joshua_Owen
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to pull a value from a field of a record if the date field is the current month. Does anyone know of a formula that does this

@Joshua_Owen - I’m guessing you want to check that the date field matches the current month and year, not just the month. If so, you could use the formula:

IF(DATETIME_FORMAT(Date, 'MM/YYYY') = DATETIME_FORMAT(NOW(), 'MM/YYYY'), '', '')

Screenshot 2019-05-14 at 19.58.32.png

(but you can easily mod this if you do just want to check that the month is the current month - just remove the YYYY from both sides)

JB