MS Access Sql - query 7 days from today

[IngDep]

Following part in an Access sql does not work - no records are displayed.

Run a query every Friday and need records that have a sign date greater than last Friday.

Any clues?


WHERE Format([Oregon_Daily].[SignDate],'MM/DD/YYYY'))>Now()-7))

 

[PHV]

Why not simply this ?
WHERE Oregon_Daily.SignDate>Now()-7

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886