That is interesting. I haven't gone that far yet. But surely it will add up to the millis. Automagic has 6 getDate() functions. My favourite 2 are getDate() to show current time and getDate(date, pattern). Actually you can easily convert the date using pattern. d = "2019-08-20"; epoch = getDate(d, ...
So it stores in milliseconds that must be why. The dateFormat is becoming more interesting. Here is the formula I'm using to convert the dates. Using the string "2019-08-20" as an example. Automagic isn't able to format this date either. So first we must convert it into epoch time. Just the time in ...
Looks like I'll be multiplying the value by 10000 to add the 4 extra zeros before formatting. timeA=1566194400*10000; timeB="{timeA,dateformat,hh:mm a}" Not so fast! After testing that, the time was substantially off. And it got me to wonder. The time is missing 4 digits and time zones are also...4 ...
I'm having some trouble to convert a date and time. It seems to either result in an error or the same variable is returned. These two values are the original data examples. Dateformat doesn't work on them. timeA="2019-08-19 06:00:00"; //Regular format timeB="1566194400" //Epoch time However, as I on...