Hi,

suppose I have a field, which I want to validate using a calculation and my user enters for a date 10/42/04

How do I know that is ont a good date ? I'd like to find this out so that i can

then use my calculation to display a message.

I thought Isvalid might work, does it? I didn't see any mention of it saying it worked for dates.

Or do i have to do my own Leap year / 31 day check? If this is the case, has anyone written such a calculation?

thanks,

sincerely,

J__

Yes, IsValid() works for dates. It'll take leap years etc into account, until the year 3000. After that you're on your own.

You can also use field-level validation, and set it to require 4-digit year dates.

Hi Vaughan,

Thanks for the verification. Handles leap years! excellent.

only up to year 3000 eh <grin> ... hmm might have to find another way <g>

thanks,

sincerely,

J__