Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

XL.Book.SetDate1904

Sets the date system mode.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 7.2 Yes Yes Yes Yes Yes

MBS( "XL.Book.SetDate1904"; bookRef )

Parameters

Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref

Result

Returns OK or error.

Description

Sets the date system mode.

Pass 1 for 1904 date system, 0 for 1900 date system (default).
In the 1900 date base system, the lower limit is January 1, 1900, which has serial value 1.
In the 1904 date base system, the lower limit is January 1, 1904, which has serial value 0.

See also


XL.Book.SetActiveSheet   -   XL.Book.SetDefaultFont

Feedback: Report problem or ask question.




Links
MBS FileMaker tutorial videos