Function reference

Tests whether a string value is a valid date.

IsDate ( datavalue )


Argument Description
datavalue A string whose value you want to test to determine whether it is a valid date

Data type: Boolean
Returns true if datavalue is a valid date and false if it is not.

Example1:
This expression returns true:
IsDate(‘Jan 1, 99’)

Example 2:
This expression returns false:
IsDate(‘Jan 32, 2005’)

Example 3:
This expression returns a day number or 0.
If [data] contains a valid date, the expression returns the number of the day, and otherwise returns 0:

If( IsDate( ‘[data]’ ) , DayNumber( Date(‘[data]’) , 0 )

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment