| 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 number for the workbook. | $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 ))
Blog Entries
This function checks for a license.
Created 6th February 2015, last changed 6th February 2015
