Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Date/Time format issue in filter condition of Report Definition

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.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us