Filter between Last 2 years and last month

[Lynda1]

My brain tells me that this filter should give me 2024, 2025 and up to March 2026.

In Platform Analytics it gives me 2025 to March 2026.

Any suggestions on getting the true last 2 years and up to last month?

[GlideFather]

Hi @Lynda1,

 

I have lived in 3 different european countries and I can tell you that many people understand "this", "next" and "last" completely differently in the date and time perspectives 😄 

When you say "last month", it is understood 1st to 21st April, or "last month" is March and April is "this month"?

It might sound silly but I have already missed many fun events just due to being there the next instead of this and vice versa... I don't know how this works in ServiceNow (maybe following US conventions) but what you can try to filter is something like this:

• Created after 2 years ago OR on this month
  • it should cover the full 2025 + 2026 + this month (April)

• Created (relative) after 2 years ago
  • this month is less than 2 years ago so it shall be included

This is just an example, I didn't know what field are you using, so I selected a random date field (Created) but for showing the condition it shall be sufficient.

Let me know if that worked for you or let's discuss it frther

[GlideFather]

Now when I read it again, you might want to set it similarly:

 

Too much screens for today, I will come back tomorrow, sorry if I don't make sense..

[Lynda1]

I tried the Relative approach. It did not like that at all and provided not data.  I tried the 2nd suggestion and gave me data 1/1/2025 to 3/31/2026.

Trying to get 1/1/2024 to last month aka March seems to be impossible in ServiceNow filters

[GlideFather]

So maybe "Created after 3 years ago +++ Created not on this month"? This is way too mathematical for me 😛