Monkeybread Software - MBS FileMaker Plugin: XL.Date.TimeStampToDouble

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

XL.Date.TimeStampToDouble

Converts a date to a numeric value for writing in a number cell.

Component	Version	macOS	Windows	Linux	Server	FileMaker 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 )

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 ))

Blog Entries

MBS FileMaker Plugin, version 5.0pr10

Created 6th February 2015, last changed 6th February 2015

XL.Date.Pack - XL.Date.UnPack