Difference between revisions of "Manuals/calci/DATETOJS"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''DATETOJS(Date)'''</div><br/> *<math>Date</math> is any date. ==Description== *This function takes date and converts it to JS Date standards ba...") |
|||
| Line 12: | Line 12: | ||
==Examples== | ==Examples== | ||
| − | *DATETOJS("2001/3/20") = | + | *DATETOJS("2001/3/20") = "2001-03-19T18:30:00.000Z" |
| − | *DATETOJS("May 25 2015") = | + | *DATETOJS("May 25 2015") = "2015-05-24T18:30:00.000Z" |
| − | *DATETOJS("03/25/2015") = | + | *DATETOJS("03/25/2015") = "2015-03-24T18:30:00.000Z" |
| + | *DATETOJS("next month") = "2022-06-27T06:30:00.000Z" | ||
==See Also== | ==See Also== | ||
Latest revision as of 05:40, 27 May 2022
DATETOJS(Date)
- is any date.
is any date.Description
- This function takes date and converts it to JS Date standards based.
- JavaScript Date objects represent a single moment in time in a platform-independent format.
- Date objects contain a Number that represents milliseconds since 1 January 1970 UTC.
- A JavaScript date is fundamentally specified as the number of milliseconds that have elapsed since midnight on January 1, 1970, UTC.
- This date and time is the same as the UNIX epoch, which is the predominant base value for computer-recorded date and time values.
- A day is made up of 86,400,000 milliseconds.
- Given that and the size of the underlying number used to record the timestamp, and it can be calculated that the Date object can represent dates within ±100,000,000 (one hundred million) days relative to January 1, 1970 UTC.
Examples
- DATETOJS("2001/3/20") = "2001-03-19T18:30:00.000Z"
- DATETOJS("May 25 2015") = "2015-05-24T18:30:00.000Z"
- DATETOJS("03/25/2015") = "2015-03-24T18:30:00.000Z"
- DATETOJS("next month") = "2022-06-27T06:30:00.000Z"
See Also
References