Validation of Date Values

[renzlo]

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

[Reverend Jim]

You can use the Year property of a date to get the year number and compare it to the current year.

[renzlo]

Thanks Jim, I'll try it, is this the best way?

[Reverend Jim]

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.

[TnTinMN]

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.

[Reverend Jim]

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.