Last 3 months date ranges in Platform analytics filter

[MHimabindu]

Hello Community,

I'm working with Problem Management Platform Analytics, which includes an interactive filter to apply queries based on the Opened date. When selecting the "Last 3 Months" option, the system returns a date range of 01‑10‑2025 to 31‑01‑2026.

However, based on ServiceNow's standard logic for relative dates from ServiceNow docs (link provided below), the expected range should be: 01‑10‑2025 to 16‑01‑2026 (where the end date aligns with the current/query date).

https://www.servicenow.com/docs/bundle/zurich-platform-user-interface/page/use/common-ui-elements/co...

Has anyone encountered this behavior or knows what might be causing the end date to extend to the end of the month instead of the current date?

Any insights would be appreciated..

[Dr Atul G- LNG]

Hi @MHimabindu 

This is expected behavior, as the system takes the current date and goes back three months to the first day of that month. I believe we cannot change this, based on my understanding.

[MHimabindu]

Hi @Dr Atul G- LNG ,

But the system displays future date. Ideally it should be 01‑10‑2025 to 16‑01‑2026   but I see the range in filter as 01‑10‑2025 to 31‑01‑2026 (attached screenshot)

Thank you.

[Dr Atul G- LNG]

Hi @MHimabindu 

here is good read:

https://www.servicenow.com/docs/bundle/zurich-platform-user-interface/page/use/common-ui-elements/co...

https://www.servicenow.com/community/platform-analytics-forum/last-x-months-what-is-the-intended-log...

[Dr Atul G- LNG]

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0748904. @MHimabindu