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 incorrect when report is exported



When the user exports the report or schedules a report, the time format is fetched along with date, in Pega Customer Service 7.1.3.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a New Report and include a Date Time property.
  2. Add the control to display only the time.
  3. Run the report, property is displaying with the time alone.
  4. Click on Export to excel the property’s time format is in Date time format instead of time alone.
  5. Schedule this report and the report gets delivered to your mailbox. When user opens the excel, the property is having date time value.

Root Cause

A defect in Pegasystems’ code or rules.

When scheduling the report, the batch requestor runs an agent and takes the default short datetime format.


Perform the following local-change:

Create a custom sql function alias with source as shown below in order to display time alone, in this case specific to Australian time zone:

<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATE'">
<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATETIME'">

THEN SUBSTR(TO_CHAR({1} at time zone 'Australia/Melbourne','YYYYMMDD hh24:mi:ss'),10,8)


Give this function in the column from the function builder in the report definition.

Published March 25, 2017 - Updated December 2, 2021

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