Next Month Formula

Hello Everybody, I am new to Airtable, would like to ask for a formula that shows me all records coming next month depending on a start date. in other words, I am sending this for operations people, and they want to see all their projects a month ahead. Can you guys help me with that?

You don’t need a formula. You can just use the filters. “Start Date” is within “the next month.”

Just to build on this a little more…

You can create a new view for your operations people to use that already has a filter defined.

The filter might be something like this:

Will that work for you?

1 Like

Thankyou guys so much, That worked , not sure if it’s accurate though, I see some records the due date is August, which is the current month, is there a reason for that?

Try this instead.

Add a new column named IsNextMonth that has the following formula:

AND(IS_BEFORE({MyDateField}, DATEADD(DATETIME_PARSE(DATETIME_FORMAT(TODAY(), '01-MM-YYYY'), 'DD-MM-YYYY'), 2, 'month')), OR(IS_SAME({MyDateField}, DATEADD(DATETIME_PARSE(DATETIME_FORMAT(TODAY(), '01-MM-YYYY'), 'DD-MM-YYYY'), 1, 'month'), 'hour'), IS_AFTER({MyDateField}, DATEADD(DATETIME_PARSE(DATETIME_FORMAT(TODAY(), '01-MM-YYYY'), 'DD-MM-YYYY'), 1, 'month'))))

It looks like this:

image

Then add a filter IsNextMonth = 1:

image

That should filter out the results to do what you’re after. Please let me know if it doesn’t work for you.

Then hide the IsNextMonth field if you don’t want to see it in the grid.

Also, the is within the next month didn’t work as I had originally had thought.

What it actually does is include today’s date 13Aug2020 all up until the same day next month 13Sep2020 which wasn’t what you were originally after. My bad. :slightly_smiling_face:

image

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