2
Vote

Parse function

description

The Date function 'Parse' doesn't take into consideration the difference between the UTC value of the date in the database and the presentation of the date on screen.
A date entered in Amsterdam (UTC+1) like 01/01/1991 will be represented as
Year: 1990
Month: 12
Day: 31
While you expect:
Year: 1991
Month: 01
Day: 01

comments

nathanielm wrote Dec 20, 2016 at 7:06 PM

This is a confirmed issue. A date entered in EST (UTC -5:00) as 1/21/2017 3:00 AM is returned as 1/21/2017 8:00 AM.

wrote Dec 20, 2016 at 7:07 PM