Verify if a date is between two other dates

[MoonBlosm]

I have a [contractstart] and an [Year1end] dates. I then have another
[TaskStart] and want to return a value, "Year 1" if that date falls between
the start and stop dates. I am stumped. I have to do this three times for
three different years of the contract.

Any help would be much apreciated.

Thanks in advance!

 

[Dale Fye]

Moon,

Can you give us a little more detail?

1. How about the table structure (more than just these 3 fields) and a
couple of sample rows of data from your table
2. "want to return a value, 'Year 1' if that date falls between the start
and stop dates". What stop date? Is there a [ContractStop] field?
3. Are the Tasks in the same table as the contracts, or are these two
different tables?
4. Do you want to run a query? If so, is this a SELECT query, or do you
want to update another field based on the values returned?
5. What do you mean you have to do this three times for 3 different years?
Do you have fields [Year1End], [Year2End], [Year3End]