Re: Date validation
- From: "Al Camp" <anon@xxxxxxxx>
- Date: Mon, 2 May 2005 08:46:46 -0400
Chris,
Since it's an exam item, your son should work out the solution, or see
his instructor.
He'll need to use the Month Function and the Day Function of an entered
date (ex. [TestDate]).
If TestDate = 9/14/2005 then...
Month(TestDate) would equal 9
Day(TestDate) would equal 14.
Hint: If any TestDate has a Month of 11 then it's OK.
hth
Al Camp
"ChrisK" <chris@xxxxxxxxxxxxxxxxxxx> wrote in message
news:ttode.21388$vU4.3565@xxxxxxxxxxxxxxxxxxxxxxx
> Can anyone help with a small date validation problem which my son is
> struggling with as part of a school exam project.
> He needs to validate a date entered but ensure it is between 1st November
> and 23rd December irrespective of year. The methods he has already tried
> automatically put in the current year of 2005 but he wants it so that the
> year does not matter as long as it is between the specified dates.
>
> Hope you can understand this and that someone can help.
>
> Chris K
>
>
.
- References:
- Date validation
- From: ChrisK
- Date validation
- Prev by Date: Form created by crosstab query
- Next by Date: Re: deleting last record on filtered form causes form to become blank
- Previous by thread: Re: Date validation
- Next by thread: Re: Forms w/ multiple users
- Index(es):
Relevant Pages
|
