Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
IsDate Method

SqlFunctions.IsDate Method

.NET Framework 4.6 and 4.5

Indicates whether the input value is a valid date or time.

Namespace:  System.Data.Objects.SqlClient
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

<EdmFunctionAttribute("SqlServer", "ISDATE")> _
Public Shared Function IsDate ( _
	arg As String _
) As Nullable(Of Integer)


Type: System.String

The tested value.

Return Value

Type: System.Nullable(Of Int32)
1 if the input expression is a valid date or time value of datetime or smalldatetime data types; otherwise, 0.

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see HOSTNAME (Transact-SQL).

.NET Framework

Supported in: 4.6, 4.5, 4

.NET Framework Client Profile

Supported in: 4
© 2015 Microsoft