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

DateValue function does not display the correct value



DateValue function does not display the correct value.

Error Messages

Not Applicable

Steps to Reproduce

Use the DateTIme library - @dateValue(.Date)
  • Input - 20190331 Output - 17986
  • Input - 20190401 Output - 17986
  • Set the operator timezone as Europe/London

Root Cause

Issue with the Operator timezone. Since the Daylight saving has started for Europe/London timezone, there is an hour's difference in time.
Input to the dateValue function is 20190301 and 000000 is considered as the time.
This timezone has a one hour difference. Hence, the time is 230000. Therefore, the same value is calculated for 31st March and 1st April.


Perform the following local-change:

Append T000000.000 GMT to the user input date.

@dateValue(param.Date+"T000000.000 GMT")
Suggest Edit

Published August 15, 2019 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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