Table of Contents

TFlxDateTime Record

Use this class to convert between a Date expressed on Excel format (a double) and a TDateTime.

Syntax

Unit: FlexCel.Core

TFlxDateTime = record;

Methods

Name Description
ToOADate Overloaded
ToOADate(TDateTime, Boolean)
ToOADate(TDateTime, 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.