SA-16065

Summary

Date/Time format added in a report definition filter condition in Production environment is different from the development environment. It also changes based on the browser.

For example, if the required date in filter condition is 1st Aug 2015 11:59:59 PM.
The date appears different in different environments:

Development environment (IE8): 01/08/2015 11:59:59 PM
Development environment (Chrome): Aug 1, 2015 11:59:59 PM
Production environment: 02-Aug-2015 1:59:59 PM

Error Messages

Not Applicable

Steps to Reproduce

1. Create a report definition
2. Add filter condition for a date/time property
3. Provide a value to date/time filter condition
4. Run the report definition in different browsers to observe the difference

Root Cause

A defect or configuration issue in the operating environment.
The datetime format in report definition filter value takes the browser default language setting to format the value.
Function pzConvertStandardToLocalizedFormat calls format function with null parameter for locale/timezone which then takes browser's default setting.

[ return PRDateFormat.format(null , null , PRDateFormat.DEFAULT_DATETIME_DEFAULT, theDate) ;]

Therefore, the value generated is in different formats in chrome and IE browsers.

Resolution

 

Modify browser's language setting to be similar in all browsers.