TFlxDateTime.ToOADate Method
Overloads
TFlxDateTime.ToOADate(TDateTime, Boolean)
Converts a DateTime into a Double on Excel format for dates (Ole Automation Format).
Syntax
Unit: FlexCel.Core
class function TFlxDateTime.ToOADate(const value: TDateTime; const Dates1904: Boolean): Double; static; overload;
Parameters
| <-> |
Parameter |
Type |
Description |
| const |
value |
TDateTime |
DateTime you want to convert. |
| const |
Dates1904 |
Boolean |
When true dates start at 1904 (pre-OSX macs) instead of 1900 (Windows) |
Returns
The value as a double on Excel format.
See also
TFlxDateTime.ToOADate(TDateTime, Boolean, Boolean)
Converts a DateTime into a Double on Excel format for dates (Ole Automation Format).
Syntax
Unit: FlexCel.Core
class function TFlxDateTime.ToOADate(const value: TDateTime; const Dates1904: Boolean; const FirstIsDec1899: Boolean): Double; static; overload;
Parameters
| <-> |
Parameter |
Type |
Description |
| const |
value |
TDateTime |
DateTime you want to convert. |
| const |
Dates1904 |
Boolean |
When true dates start at 1904 (pre-OSX macs) instead of 1900 (Windows) |
| const |
FirstIsDec1899 |
Boolean |
If true, the minimum date returned will be Dec 31, 1899. If false, the minimum is Jan 1, 1900.
Note that none of them is valid of a date of 0. Excel shows 1900-01-00 in that case. |
Returns
The value as a double on Excel format.
See also