Help on Data criteria: no record with 10 days of date already specified in field

[losamfr17]

Hi,

Can you please help me learn this out? I am using the Query design.
I want to create a query with the following date criteria: if the date in "Dep Date" is within 10 days of the date in "referral file" field, do not show me this record.

Please advise.

Thank you

 

[james_lankford]

try

select 
  * 
from 
  some_table as t 
where 
(
  (
    [Dep Date] - 10 < t.referral file 
    or 
    [Dep Date] + 10 > t.referral file
  )
)

or

select 
  * 
from 
  some_table as t 
where 
(
  not 
  (
    t.referral file < [Dep Date] - 10  
    or 
    t.referral file > [Dep Date] + 10 
  )
)

 

[losamfr17]

It worked, thank you so much!