Skip to content

G
g1
Closed
Opened by S Anand@s.anand
Report abuse New issue

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