IsDate Function

  • Updated

The IsDate function determines if an expression is a valid Date (or a DateTime with a zero time offset).

Syntax

 

The IsDate function determines if an expression is a valid Date (or a DateTime with a zero time offset).

 

IsDate(expression)

 

 

Arguments:

 

 

 

expression

Expression - string expression to check.

Remarks

  • Use the IsDateTime function to determine if an expression is a valid DateTime.
  • Example: IsDate("12/31/2005") returns true.
  • Example: IsDate("2005-12-31") returns true.
  • Example: IsDate("2005-12-31Z") returns true.
  • Example: IsDate("2005-12-31T00:00:00Z") returns true.
  • Example: IsDate("12/31/2005 6:00:00 PM") returns false.
  • Example: IsDate("2005-12-31T18:00:00") returns false.
  • Example: IsDate("2005-12-31T18:00:00Z") returns false.
  • Example: IsDate("2013-13-40") returns false.
  • Example: IsDate("3:00pm") returns false.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.