Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Getting month and year from other fields

Topic Labels: Dates & Timezones
5850 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Okay trying to do a bill manager and I have months listed and check marks for when a month is complete. I have put the day of the month in the date field. I would like to get the month off of the check marks and year as current year. Is this possible or am I asking for too much.


1 Reply 1

I am not sure exactly what you’re asking for, so here’s some different solutions in the hopes one accomplishes your goal:

A formula field with MONTH({Date field}) will give you the month number from a date and similarly YEAR({Date field}) will give you the year. You could also use DATETIME_FORMAT({Date field}, 'MMMM YYYY') to get something like “June 2021”.

To compose a string of text that is (Month name from a date field) (Current Year), you could use a formula like this:

DATETIME_FORMAT({Date field}, 'MMMM') & " " & YEAR(TODAY())