Date Range

[radhujs]

Suppose we are given three columns:


- Visit 1 Date Open
- Visit 1 Date Close
- Visit 1 Actual Date

If the Visit 1 Actual Date is not within Open and Close window, I want the list of all the people.

How do I do that?

Thanks

[June7]

Criteria under the ActualDate field:

NOT BETWEEN [Date Open] AND [Date Close]

[pbaldy]

Try

SELECT * FROM TableName
WHERE Actual < Open OR Actual > Closed

using all the actual names of course.