Getting month and year from other fields

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.


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())

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.