Query ?

Topic

New Reply

Hi everyone,

I have a query with a date field in it. I want to query only the information where the date in the date field is more than 7 days old….what must I put in the criteria line?

Thanks in advance.

Reply | Quote

Replies

You could try

Date()-7

Reply | Quote

thanks for the reply, but I keep getting records with todays date…any other suggestions? Currently there isn’t any records in there older than 7 days…so I shouldn’t have any records returned when the query runs!

Thanks

Reply | Quote

myDate<=DateAdd("d",-7,Date())

Reply | Quote

try this <=Date()-7

Reply | Quote