Sign Up ›
  • ccrawford07
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
2 replies

Comparing datetime fields in SOQL

Hello,

I'm trying to do a query like this:

Code:
SELECT Id, LastModifiedDate, Name, updatedDate__c FROM Account WHERE LastModifiedDate > updatedDate__c

But I get an error:

Code:
ERROR at Row:1:Column:89
unexpected token: updatedDate__c


How can I do a quick date comparison in SOQL?

Thanks!
2 replies

Comparing datetime fields in SOQL

Hello,

I'm trying to do a query like this:

Code:
SELECT Id, LastModifiedDate, Name, updatedDate__c FROM Account WHERE LastModifiedDate > updatedDate__c

But I get an error:

Code:
ERROR at Row:1:Column:89
unexpected token: updatedDate__c


How can I do a quick date comparison in SOQL?

Thanks!
3 replies

How to trigger call external application?

Hi all,

I have a custom object, it is named Address. When user add a record for Contact, I want to get data from MapQuest application by using Mapquest API and add data into Address.
How to do it? As I know trigger can not call S-Control, anyone can help me.

Thanks,