Date differences in SQL

[Gavuk]

Hiya all (again!!)

I have a main table with an ordered date and a actual delivery date. Im trying to query the database for all the equipment that has been ordered and not yet been delivered oras been 7 days from ordering and not been deliverd. Does anyone know the SQl for this kind of request:

Im guessing something like.

Select * from maintable where orderdate > 7 now() and actualdeliverydate = "".

I know the syntax cant be far off that but cant get it to work can anyone help?? Cheers

 

[BillPower]

This should do it:

SELECT * FROM maintable WHERE (((actualdeliverydate) Is Null) AND ((DateDiff("d",[orderdate],Now()))>7));

Regards

Bill

 

[Gavuk]

Thanks bill!!

Gav