"Last 3 Months" Date Filter range shows the end date of current month instead of exact date of the current month - Support and Troubleshooting

"Last 3 Months" Date Filter range shows the end date of current month instead of exact date of the current month Summary .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Yes, this is expected behavior. " Last 3 Months " Date Filter pulls the data between midnight on the first of the month three full months ago and the current day and time but the filter range will show till end date of current month.

For example, if you are running a report on 15th April, then " Last 3 Months " Date Filter pulls the data between January 1st up until April 15 but the date range will show end of current month (that is April 30). Refer following screenshot which shows the system returns a date range of 01‑01‑2025 to 30‑04‑2025.

For example, when you are filtering the incidents records with opened on last 3 months date filter, the system generates the following URL which confirms it is retrieving the data between the date range of beginningOfLast3Months and endOfLast3Months .

https://instancename.service-now.com/incident_list.do?sysparm_query=opened_atONLast%203%20months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()&sysparm_first_row=1&sysparm_view= This is working as designed and expected behavior in the base system. If you need this logic to be reviewed in future releases, it would be considered as an IDEA request.

You can submit an idea request for this to be reviewed in a future release.

Please follow the KB article KB0755878 - Idea Management for customer enhancement requests while submitting an idea request. You can create an idea request including a business justification and all the details about your request.

Related Links .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Refer Values for date/time fields for more details.