Can't figure out expression to use for no date

  • Thread starter Thread starter Jason Trolian
  • Start date Start date
J

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.
 
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())
 
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())




.
Click to expand...
 
Back
Top