difference between two dates +5 days

[lotarugg]

Hi, I'm trying to build a query to generate a report based on the difference between two dates being greater than 5 days. On the query setting the criteria for the "date_acknowedged" field I'm trying to write a statement that says if it is 5 days greater than the "date_received" field. Something like

Datediff > [date_received] +5

Have searched everywhere for the right syntax

Cheers

 

[JamesMcS]

Hi! You need a field in your query thusly:

datediff("d",date_received,date_acknowledged)

and the criteria for that should be >5.

 

[lotarugg]

Awesome Thanks very much

 

[JamesMcS]

Nyet problemski!