Pre-defined report date ranges working as expected - Support and Troubleshooting

Pre-defined report date ranges working as expected Issue  Customer indicates that the pre-defined date ranges are not calculating as expected.

Ex. Today's Date: 05/14/2019 (MM/DD/YY)

Filter condition: Opened -> on -> Last 3 Months

Expected results: 02/01/2019 - 04/30/2019

Actual Results: 02/01/2019 - 06/01/2019

Cause Working as expected

Related Links Possible update to customer:

The pre-defined date ranges are explained in the following doc: https://docs.servicenow.com/csh?topicname=c_ValuesForDateTimeFields.html&version=latest

To explain further: The last3Months in the report filter builds into the following : opened_atONLast 3 months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()

We can examine the javascript by running the GlideSystem api's in the Scripts - Background: gs.print(gs.beginningOfLast3Months()); gs.print(gs.endOfLast3Months());

output (based on EST timezone): *** Script: 2019-02-01 08:00:00 *** Script: 2019-06-01 06:59:59

If you are wanting to exclude this months data, can add an Opened -> not on->This Month; or use a between for the exact dates.

If you are wanting to report based on quarters; can use the Last or This Quarters which builds a query: opened_atONThis quarter@javascript:gs.beginningOfThisQuarter()@javascript:gs.endOfThisQuarter() - or - opened_atONLast quarter@javascript:gs.beginningOfLastQuarter()@javascript:gs.endOfLastQuarter()

and calculates to:

gs.print(gs.beginningOfLastQuarter()); gs.print(gs.endOfLastQuarter()); gs.print(' '); gs.print(gs.beginningOfThisQuarter()); gs.print(gs.endOfThisQuarter());

output: *** Script: 2019-01-01 08:00:00 *** Script: 2019-04-01 06:59:59 *** Script: *** Script: 2019-04-01 07:00:00 *** Script: 2019-07-01 06:59:59