I just discovered what I think is a serious bug with 4D reading dates from an object.
If you store a 4D date value in an object and retrieve it the value is correct. However, if you retrieve a date that is stored in the format YYYY-MM-DD, the date returned is one day less that the date stored. The code below illustrates the issue. I have only tested this on Mac OS using 4D v17.1 (Note: I tested this at 6:30 pm PST and am not sure if GMT offset has any effect) Has anyone else experienced this issue? Thanks, Bart C_DATE($4dDate;$apiDate) C_OBJECT($obj) $obj:=New object $today:=Current date OB SET($obj;"4Ddate";$today) OB SET($obj;"apiDate";"2019-02-24") $4dDate:=ob get($obj;"4Ddate";Is date) // date returned is correct 2019-02-24 $apiDate:=ob get($obj;"apiDate";Is date) // ERROR: date returned is 2019-02-23 ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************