• ekb
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies

Hello

 

I am building an interface to salesforce to extract some data. I am trying to query the data that has been modified in the last 2 days. I formulated the query as below, but I am getting a MALFORMED_QUERY error. Initially i enclosed the data in quotes, but i got an explict error not to use quotes, any idea ?

 

 

select column1, column2  from sobject_name where lastModifiedDate >=2009-07-27T08:00:00.000

 

 

LastModifiedDate >=2009-07-27T08:00:00
^
ERROR at Row:1:Column:123
line 1:123 no viable alternative at character '<EOF>'
  • July 27, 2009
  • Like
  • 0

Hello

 

I am building an interface to salesforce to extract some data. I am trying to query the data that has been modified in the last 2 days. I formulated the query as below, but I am getting a MALFORMED_QUERY error. Initially i enclosed the data in quotes, but i got an explict error not to use quotes, any idea ?

 

 

select column1, column2  from sobject_name where lastModifiedDate >=2009-07-27T08:00:00.000

 

 

LastModifiedDate >=2009-07-27T08:00:00
^
ERROR at Row:1:Column:123
line 1:123 no viable alternative at character '<EOF>'
  • July 27, 2009
  • Like
  • 0