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. |