
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 04, 2021 01:10 PM
I’ve built a simple tracking for my recurring expenses and I want one of the fields to show the current month with the information in the field next to it.
I can’t seem to find how to do that.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 04, 2021 06:19 PM
Welcome to the Airtable community!
You can use a formula field to display the current month, and then concatenate it with the value of another field
DATETIME_FORMAT(TODAY(), 'MMMM') & " " & {other field}
However, when the month changes, the formula will update to the new month, which may not be what you want. If you want the field to say “January” this month, and still say “January” when “February” rolls around, you will need to have a different method of specifying the date, such as using the month in which the record is created.
DATETIME_FORMAT(CREATED_TIME(), 'MMMM') & " " & {other field}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 04, 2021 06:19 PM
Welcome to the Airtable community!
You can use a formula field to display the current month, and then concatenate it with the value of another field
DATETIME_FORMAT(TODAY(), 'MMMM') & " " & {other field}
However, when the month changes, the formula will update to the new month, which may not be what you want. If you want the field to say “January” this month, and still say “January” when “February” rolls around, you will need to have a different method of specifying the date, such as using the month in which the record is created.
DATETIME_FORMAT(CREATED_TIME(), 'MMMM') & " " & {other field}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 04, 2021 09:22 PM
Thanks. That worked perfectly.
