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.