Filter Next Month & Following Month

[markalves]

Hello,

I would like to create a formula for filtering out the data of the next month. I also need to filter out the following month as well. For example, it is January now, so I want to only show the data with February dates.  I then want a separate filter to show only the data in March.

[Qiu]

@markalves 
This should help.

[RolandSchubert · Accepted solution]

Hi @markalves ,

the DateTimeFunction work well with a Filter tool.

Using DateTimeFirstOfMonth/DateTimeLastOfMonth with DateTimeAdd gives you flexibility in selecting the date range.  I've attached a sample for the next and the following month, but it can be easily adjusted for other ranges.

Let me know if it works for you.

Best,

Roland