FlxDateTime Class
Use this class to convert between a Date expressed on Excel format (a double) and a TDateTime.
Syntax
Namespace: FlexCel.Core
public static class FlxDateTime
Fields
| Name | Description |
|---|---|
| OADateMinAsDouble | Minimum date allowed in a OLE Automation date. |
| OADateMaxAsDouble | Maximum date allowed in a OLE Automation date. |
Methods
| Name | Description |
|---|---|
| ToOADate | Overloaded ToOADate(DateTime, Boolean) ToOADate(DateTime, Boolean, Boolean) |
| TryToOADate | Converts a DateTime into a Double on Excel format for dates (Ole Automation Format). |
| FromOADate | Converts a Double on Excel format for dates (Ole Automation Format) into a DateTime. |
| IsValidDate | Returns true is the double value can be converted into and Excel date. |
| TryFromOADate | Converts a Double on Excel format for dates (Ole Automation Format) into a DateTime. |
| ToISO8601 | Returns a date formatted as ISO8601 |
| ToISO8601Local | Returns a date formatted as ISO8601 from an OLE Automation Date. It won't convert to UTC time, but use local times instead. |