DateValue function does not display the correct value
DateValue function does not display the correct value.
Steps to Reproduce
Use the DateTIme library - @dateValue(.Date)
- Input - 20190331 Output - 17986
- Input - 20190401 Output - 17986
- Set the operator timezone as Europe/London
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.