Jump to content

This topic is 7393 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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__

Posted

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

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

Posted

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__

This topic is 7393 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.