0

Hi, All,

I need to check if the date values is valid this current year, for example, February 29, 2012, I have used Isdate function but it says "True", is there any other way to do this?

Thanks in advance.

renzlo

3
Contributors
5
Replies
9
Views
4 Years
Discussion Span
Last Post by Reverend Jim
0

It depends on how you define "valid". If your intention is to see if it is a date in the current year, then I believe it is the easiest way.

0

I realize you have marked this thread solved, but you do realize that your example is a valid date don't you? 2012 is a leap year, hence IsDate(" February 29, 2012") will return true.

IsDate("February 30, 2012") would return false.

0

That's why I asked about the specific definition of "valid" in this context. It would also depend on the input method. For example, if it was a date from a datepicker then picking Feb 30 would never be an option.

Edited by Reverend Jim

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.