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