Can't figure out expression to use for no date

[Jason Trolian]

I am running a querry on an existing collection database.
I am trying to querry accounts that have never been
modified or were modified over 10 days ago. I am usign
this expression to generate all accounts with no activity
in 10 days or more but I am not sure how to make it pull
up records that have never been modifed. The expression I
am using is <=(Date()-10) What should I add to this to
make sure that it finds all accounts that have no modified
date I tried <=(Date()-10)or =(0) but that didnt work.

 

[John Spencer (MVP)]

The criteria for no date would be Is Null

Assuming that you only have one Modified date

Field: LastModified
Criteria: Is Null OR <= DateAdd("d",-10,Date())

 

[Jason Trolian]

Thank You John

-----Original Message-----
The criteria for no date would be Is Null

Assuming that you only have one Modified date

Field: LastModified
Criteria: Is Null OR <= DateAdd("d",-10,Date())




.