FormHandler table parses dates in the wrong time zone
- My birthday is on 23 Nov.
-
datetime.datetime(2019, 11, 23).timestamp() == 1574485200
. I get the same timestamp if I save the cell in Excel as a date and read it - FormHandler parses Excel files with this date and returns
1574485200000
-
moment(1574485200000).toString() == "Fri Nov 22 2019 19:00:00 GMT-0500"
in New York -
moment.utc(1574467200000).toString() == "Sat Nov 23 2019 00:00:00 GMT+0000"
in New York and in India
Hence, use moment.utc() instead of moment() when parsing dates from FormHandler
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information