Query - determine no activity

[jasonhuibers]

Columns:

Buy_Date (Activity date)
Activity_Flag (1=there was activity)


How can I query my sql database for non actvity for 1 month, 3 month and 6 months?

 

[jrbarnett]

For 30 days:

select *
from yourtable
where dateadd ("d", buy_date, 30) < date
and activity_flag <> 1

If a 1 is only written in when activity takes place, you need to change "<> 1" to "is null"

For the other date periods, change the number in the DateAdd line.

John