Skip to main content
Question

Problem using “Date – is within – the past month” filter in Rollup field

  • November 13, 2025
  • 2 replies
  • 21 views
OlhaZalevska
Forum|alt.badge.img+4

I’ve run into a problem that I can’t solve.

I’m using a Rollup field, and I need to get the total for the previous month.
I’m using the filter “Date – is within – the past month”, but it gives me the total for both the current and previous months.
When I set fixed dates for the previous month (from the 1st to the last day), the calculation works correctly.

Below, I attached a screenshot with my filter settings and the result.
I expected the numbers to be the same with this configuration, but they are different.

The issue is that I can’t use fixed dates, because I need the period to be calculated dynamically.

 

 

2 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9808 replies
  • November 13, 2025

The “within the past month” option is a little confusing, because it actually gives you the previous 30 days from today.

I’m not sure if there’s an easier way to solve this, so I think you will probably need to create a formula field in your linked table that returns “Yes” or “No” for each record to indicate if each record is in the last calendar month, and then you can filter on that formula field for the word “Yes”.

I’m not at my computer right now, so I can’t work on that formula for you at the moment, but maybe somebody else will be able to help write the formula for you by the time I get back to my computer later tonight.

- ScottWorld, Expert Airtable Consultant 

Mike_AutomaticN
Forum|alt.badge.img+28
  • Mike_AutomaticN
  • Genius
  • 1547 replies
  • November 13, 2025

Hey ​@OlhaZalevska,

As mentioned by ​@ScottWorld above, past month will actually show previous 30 days. You will want to go with a formula as also mentioned by Scott (this guy really knows his stuff lol). However, I would suggest a more dynamic formula (ratehr than a yes/no output).

I’d suggest using a “Months from current” formula, which will output 0 if current calendar month, -1 if immediately previous calednar month, 1 if immediately next calendar month, so on and so forth. E.g. 2 calendar months ago will show -2.

In this way, you can filter for -1 for your current need. If you ever have yet a different need you’ll just filter for whaterver Months from Current you need :D

Formula below:

 

(
  (YEAR({Your Date Field}) - YEAR(TODAY())) * 12
  +
  (MONTH({Your Date Field}) - MONTH(TODAY()))
)


Please make sure to reach out if you need any help setting this up! I’d be happy to show you around.

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel


Terms & ConditionsAccessibility statement