J__ Posted December 2, 2004 Posted December 2, 2004 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__
Vaughan Posted December 2, 2004 Posted December 2, 2004 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.
J__ Posted December 2, 2004 Author Posted December 2, 2004 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__
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now