| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XL.Date.TimeStampToDouble
Converts a date to a numeric value for writing in a number cell.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 5.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Date.TimeStampToDouble"; bookRef; timeStamp ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
| timeStamp | The time, date or time stamp to convert. | Get ( CurrentTimeStamp ) |
Result
Returns value or error.
Description
Converts a date to a numeric value for writing in a number cell.This uses current time zone.
Examples
Convert current timestamp:
MBS( "XL.Date.TimeStampToDouble"; $bookRef; Get ( CurrentTimeStamp ))
See also
Blog Entries
This function checks for a license.
Created 6th February 2015, last changed 6th February 2015
