Date and DateTime confusion

[hkp716]

Hi everyone,

I can retrieve any records with this query.  It is an issure with the Date format.  Is lastmodifieddate a date or datetime?  If i remove the LastModifiedDate >=:d AND LastModifiedDate <=:c filter the query works just fine.

Date d = system.Today().addDays(-3);
Date c = system.Today().addDays(-5);

//collect a list of records
//
List<Lead> setfollow = [SELECT Id, OwnerID, status FROM Lead WHERE LastModifiedDate >=:d AND LastModifiedDate <=:c AND Map_Record_Type__c = 'Contract/Direct Customer' AND IsConverted = FALSE AND status IN('Qualified', 'Prospecting')];

Im trying to get a list of leads that havent been modified in 4 days.

I already tried:

Date d = system.Today().addDays(-4) 

and bind it with the query but nothing shows up.

Any ideas?

-hkp716

[sfdcfox]

LastModifiedDate is a DateTime (despite the moniker). Use a DateTime function instead, or use date literals:

LastModifiedDate >= LAST_N_DAYS:5 AND LastModifiedDate <= LAST_N_DAYS:3

See the Web Services Developer's Guide section on Date Literals for more details.

[hkp716]

Tried using literals, couldn't get them to fit my needs..... i changed the query around and took out the "=" operator.  Workk for now.

I appreciate the help sfdcfox.

-hkp716