Filtering by Calendar Month

How To
,
1

Hi All,

Been trying this but can’t find an answer myself.

Every 2nd of each moth I need to collect all items from the month before, and three months before. So it looks like this:
In April 2nd, collect all items from March, and all items from January, February And March.

I don’t want to use AddMonths(now; -1) nor AddMonths(now: -3) because some months are 30 days, some are 29. etc.

Does anyone have an idea on how to help me solve this?

Thanks in advance!

2

Welcome to the Make community!

You are actually halfway there – addMonths(now; -1) is only half the solution.

You’ll need to also set the date of the month to 1 to get the data from the start of the month.

e.g.:

{{ setDate(addMonths(now; -1); 1) }}

For more information, see https://www.make.com/en/help/functions/date---time-functions#setdate--date--number-

3 Likes
3

OH! I see. That’s great. Thanks so much!

2 Likes
4

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

3 Likes