DateTime to Num rounding error

danelooman — Thu, 16 Sep 2021 14:14:01 GMT

In JS I am taking in strings like "2020-09-16 08:26:02" and converting them to numbers like "44090.35141203704"

I am using the function below and on about 25% of my attempts I am getting a rounding error. Has anyone encountered this or done something like this in a mashup/viz before?

let item = "2020-09-16 08:26:02" let parts = item.split(/[?:,| -]+/) let date = new Date(parts[0], parts[1]-1, parts[2], parts[3], parts[4], parts[5]) let returnDateTime = 25569.0 + (date.getTime() - date.getTimezoneOffset() * 60 * 1000) / (1000 * 60 * 60 * 24); return returnDateTime;

topic DateTime to Num rounding error in Integration, Extension & APIs

DateTime to Num rounding error