Date query

[okitek]

Hi,
I have a query that has a calculated field as:

PromotionDate: 90+[hiredate]

I would like to add a criteria to show those that are between two specific dates, such as 8/1/02 and 10/1/02

Any help would be appreciated.
Thanks

 

[Jon K]

In the PromotionDate column, add the Criteria:-

BETWEEN #8/1/02# AND #10/1/02#


Or you can use a parameter query and enter two dates when the query is run (copy and paste to the SQL View of a query and correct the table name):-

parameters [Enter Start Date] DateTime, [Enter End Date] DateTime;
SELECT 90+[hiredate] AS PromotionDate, *
FROM yourTable
WHERE 90+[hiredate] Between [Enter Start Date] And [Enter End Date];