G
Guest
I need to validate dates that a user would input. The date range needs to be
from 10/01/2002 and 9/30/2005. I've tried this "between #10/1/2002# AND
#9/30/2005#" without the quotes. And I've entered an Validation Text to say
"Entered Wrong Date".
When I tried to test this it would error out when you put in a date such as
9/25/2000 but when you entered a date between the correct range it comes up
with the Error Message that you've Entered the Wrong Date. This also,
happeneds when you put in a date after 9/30/2005 such as 2006 or 2008.
The user needs to be able to entered in a date between 10/1/2002 and
9/30/2005. What would be the correct format for this?
Thanks.
Donna
from 10/01/2002 and 9/30/2005. I've tried this "between #10/1/2002# AND
#9/30/2005#" without the quotes. And I've entered an Validation Text to say
"Entered Wrong Date".
When I tried to test this it would error out when you put in a date such as
9/25/2000 but when you entered a date between the correct range it comes up
with the Error Message that you've Entered the Wrong Date. This also,
happeneds when you put in a date after 9/30/2005 such as 2006 or 2008.
The user needs to be able to entered in a date between 10/1/2002 and
9/30/2005. What would be the correct format for this?
Thanks.
Donna