Legato
Legato

GoFiler Legato Script Reference

 

Legato v 1.5d

Application v 5.25a

  

 

Chapter FiveGeneral Functions (continued)

MS1904ToDate Function

Overview

The MS1904ToDate function converts Microsoft 1904 type date to a system time.

Syntax/Parameters

Syntax

qword  = MS1904ToDate ( int value | string value | float value );

Parameters

value

A date numbered from January 1, 1904 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 1904 where a date value is stored as days from January 1, 1904.

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-12-13