dates, IOS and various browsers

Ask the community
,
1

Some users might appreciate the following help about Javascript dates and IOS / various browsers compatibility issues (I would have !) So here it is :

IOS handles dates a different way as Windows or Androïd (I don’t know for Mac OS, as I can’t test). This made my table management uneffective under IOS as my wixData queries involve dates calculations. I must confess I’ve been suspecting Wix compatibility issues for a time… until I put some flags on my live website and discovered the date issue. I digged into Javascript and found that these issues are known… I found by trials and errors that only 1 date format works with IOS Safari or chrome (at least up to IOS 12.4) AND several other browsers

lowerDate = new Date(lowerYear.concat('-08-01T00:00:00'));  fails
lowerDate = new Date(lowerYear.concat('-08-01T00:00:00Z'));  fails
lowerDate = new Date(lowerYear.concat('-8-1T00:00:00'));  fails
lowerDate = new Date(lowerYear.concat('-8-1T00:00:00Z'));  fails
lowerDate = new Date(lowerYear.concat('-08-01'));  fails
lowerDate = new Date(lowerYear.concat('-8-1'));  fails

and, despite advised on some javascript forums,

lowerDate = new Date('-8-1'.concat(lowerYear));  fails 
lowerDate = new Date('-08-01'.concat(lowerYear));  fails

The only working one I found (working on Safari & Chrome IOS, Chrome, Firefox and Edge Windows, Chrome Androïd) is :

lowerDate = new Date(lowerYear.concat('-08-01T00:00:00.000Z');
or more generally :
    date = new Date('2019-08-01T00:00:00.000Z');
note that without 'Z' :
    date = new Date('2019-08-01T00:00:00.000');
works on IOS and Chrome Windows, but not on Firefox windows...

Hope it will save hours of errance to some Wix users !