ToDate(Double,Boolean,Boolean) Method

In This Topic

Converts date serial to System.DateTime value.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function ToDate( _
   ByVal value As Double, _
   ByVal isDate1904 As Boolean, _
   ByVal excelDateTimeCompatible As Boolean _
) As Date

'Usage
 
Dim value As Double
Dim isDate1904 As Boolean
Dim excelDateTimeCompatible As Boolean
Dim value As Date
 
value = CalcHelper.ToDate(value, isDate1904, excelDateTimeCompatible)

public static DateTime ToDate( 
   double value,
   bool isDate1904,
   bool excelDateTimeCompatible
)

Parameters

value: A double value indicates the date serial.
isDate1904: if set to true, the 1904 date system is using.
excelDateTimeCompatible: true if date time system is compatible with Excel; otherwise, false.

Return Value

A double value represents the date serial.

Reference

CalcHelper Class
CalcHelper Members