Notifications

423 views

Description

Fiscal period filters (ie. Last Fiscal Month) in Lists or Reports not working in New York if the system date format is set as 'dd/MM/yyyy'
The issue is reproducible on both upgraded instance and an instance provisioned as NewYork.

On instances upgrading to NewYork, Fiscal Periods are automatically converted to Business Calendars.

Steps to Reproduce

On a NewYork instance, login as admin and take the following steps: 
1. Set the property "glide.sys.date_format" to 'dd/MM/yyyy'
2. Ensure that the 'calendars_for_package' table has entries to map the Fiscal Month business calendar with the 'Incident' package.
3. Validate that the configurations in business calendar entries and business calendar filter options for Fiscal Month business calendar are correct.
4. Open incidnet.list
5. Apply the filter condition Created [On] Last 3 Fiscal Months and check the count.
6. Apply a filter condition for the same date range using the between condition instead of using the Fiscal Month condition and notice that the counts are way off.
Setting the property "glide.sys.date_format" back to the default format of 'yyyy-MM-dd' gives the correct counts.

Workaround

Option 1: Set the property "glide.sys.date_format" back to the default format of 'yyyy-MM-dd'

Option 2: Set the user's date format to 'yyyy-MM-dd'

 


Related Problem: PRB1379692

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - CMDB CI Class Models - 201909
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3

Fixed In

New York Patch 7
Orlando Patch 2
Paris

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-05-19 02:18:50
Published:2020-01-23