Show dates outside range

[Trevor Howard]

Hello, i hope you might be able to help.

I have two dates in a query, ExamRequested, and TestDate
I am trying to figure out how to show all test dates which were done 30 days over the requested date. But ignore the test dates which are inside this 30 day period.

Any pointers would be appreciated.

I have tried something like; Between [RequestDate] And [TestDate]+30

 

[MarkK]

So you want all test dates which were done 30 days over the requested date ...
testdate greater than 30 days over requestdate
testdate greater than reqestdate + 30
testdate > requestdate + 30

[COLOR="Green"]'try ...[/COLOR]
testdate > reqestdate + 30

See the steps from language to math?