Limit records by date?

rbuser

Hi Guys,

I am trying to create an End User report that only shows records (Jobs) that
have been in-shop for more than 7 days and haven't been completed (Status CO).

The field I am testing against for the period is Date In, a date field.

The Status bit is easy but I can't see how to set a search criteria that will
provide the > 7 days time criteria.

Somehow I need to test/show for Now()-Date In > 7.

Any thoughts/suggestions greatly appreciated.

Regards & TIA,

Ian

nicocizik

Hi Ian,

If you are using Access or SQLServer, try using the DateDiff SQL routine.
Something like the following would work in Access...

Select DateDiff("d", Date_In, Now())...

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com