  |
GoFiler Legato Script Reference
Legato v 1.5a Application v 5.23b
|
| Table of Contents | < < Previous | Next >> |
Chapter Five — General Functions (continued)
Overview
The MS1900ToDate function converts Microsoft ‘default 1900’ type date to a system time.
Syntax/Parameters
Syntax
qword = MS1900ToDate ( int value | string value | float value );
Parameters
value
A date numbered from January 1, 1900 as a string, float or int.
Return Value
Returns a qword as a 64-bit date time or zero on failure. Use GetLastError to retrieve a formatted error code.
On success, an ISO-8601 version of the date will be placed in the last error message which can be retrieved using the GetLastErrorMessage function.
Remarks
Certain applications employ a date counting method known as ‘default 1900’ where a date value is stored as days from January 1, 1900. There are a number of variations on this method, this version works with the 1900 basis and compensated for the leap year error in 1900.
Time values can be represented as fractions of days (except for the value as int).
The string value can be a whole number or a real number. The value is converted as appropriate and then run as an integer or as a float.
The returned value is a standard file-time value dated from 1600.
Related Functions
Platform Support
Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL
Legato IDE, Legato Basic
Page revised 2024-08-19
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.