Converts the specified value to a DateTime value.

Syntax

Visual Basic (Declaration)
Public Shared Function ToDateTime( _ ByVal value As Object _ ) As Date

Visual Basic (Usage)	Copy Code
Dim value As Object Dim value As Date value = CalcConvert.ToDateTime(value)

C#
public static DateTime ToDateTime( object value )

Parameters

value: Value to convert

Return Value

DateTime object containing the date-time equivalent to the specified value

Exceptions

Exception	Description
System.InvalidCastException	Value cannot be converted.

Example

This example converts the value to a date-time object.

C#	Copy Code
public class DateFunctionInfo : FarPoint.CalcEngine.FunctionInfo { public override string Name { get { return "DATEIT"; } } public override int MinArgs { get { return 1; } } public override int MaxArgs { get { return 1; } } public override object Evaluate (object[] args) { System.DateTime dt = FarPoint.CalcEngine.CalcConvert.ToDateTime(args[0]); return dt; } }

Copy Code

public class DateFunctionInfo : FarPoint.CalcEngine.FunctionInfo
    {
        public override string Name { get { return "DATEIT"; } }
        public override int MinArgs { get { return 1; } }
        public override int MaxArgs { get { return 1; } }
        public override object Evaluate (object[] args)
        {
            System.DateTime dt = FarPoint.CalcEngine.CalcConvert.ToDateTime(args[0]);
            return dt;
        }
}

Visual Basic	Copy Code
Public Class DateFunctionInfo Inherits FarPoint.CalcEngine.FunctionInfo Public Overrides ReadOnly Property Name() As String Get Return "DATEIT" End Get End Property Public Overrides ReadOnly Property MinArgs() As Integer Get Return 1 End Get End Property Public Overrides ReadOnly Property MaxArgs() As Integer Get Return 1 End Get End Property Public Overrides Function Evaluate(ByVal args() As Object) As Object Dim dt As Date = FarPoint.CalcEngine.CalcConvert.ToDateTime(args(0)) Return dt End Function End Class

Visual Basic

Copy Code

Public Class DateFunctionInfo
   Inherits FarPoint.CalcEngine.FunctionInfo

   Public Overrides ReadOnly Property Name() As String
   Get
   Return "DATEIT"
   End Get
   End Property

   Public Overrides ReadOnly Property MinArgs() As Integer
   Get
   Return 1
   End Get
   End Property

   Public Overrides ReadOnly Property MaxArgs() As Integer
   Get
   Return 1
   End Get
   End Property

   Public Overrides Function Evaluate(ByVal args() As Object) As Object
   Dim dt As Date = FarPoint.CalcEngine.CalcConvert.ToDateTime(args(0))
   Return dt
   End Function
End Class

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2