Dates

[Guest]

What I would like to have happen is really two things.

First - I have a FROM DATE and a TO DATE. If someone put for example
1/29/2007 in the FROM DATE and put 1/30/2006 in the TO DATE I would like
something to appear that they cannot move forward because they put an old
date in the field.

Second - I do not want then to go over 365 days from the FROM Date.

Is there a way for this to happen?

 

[Douglas J. Steele]

Where are they entering these dates? If they're parameters for a query (so
that an input box pops up asking for FROM DATE, they input a date, and then
a second box pops up asking for TO DATE), there's really nothing you can do.

However, if you're using a form, then put code in the AfterUpdate events of
the two text boxes. Remember that you can't be certain in which order they
fill the two boxes, so you have to be able to handle the other box being
empty.