Converts the given serial number to the elapsed milliseconds since 1st of January 1900. A serial date is recognized as a date by Streamsheets. You can get a serial date by using NOW().
|Date||Number||A serial number consists out of two numbers. The number to the left of the decimal defines the days since 01.01.1900. The number to the right of the decimal defines the fraction of the day.|
|UTC||Boolean||Boolean to specify if conversion should respect locale timezone, i.e. local timezone offset is subtracted. Defaults to FALSE.|
Elapsed milliseconds as a number deducted from the DateValue.
|1021072743648||The given date value represents the 10th of May, 2002, 23:19.|
|1021065543648||Same as before but respects local german timezone leading to 10th of May, 2002, 21:19.|
|1628585618164||Current time in UTC as for local german time 10.08.2021, 10:53.|