Help

Re: Next Month Formula

1206 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ahmed_Elagami
7 - App Architect
7 - App Architect

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?

5 Replies 5
Patrick_Baker
6 - Interface Innovator
6 - Interface Innovator

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:

image

Will that work for you?

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.

gwynn_kruger
6 - Interface Innovator
6 - Interface Innovator

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