How do I query out a greater than / less than based on a static date?

So far I have:

(acc.[Most_Recent_Auto_Loan_Application__c] > 2017-08-01 AND
acc.[Most_Recent_Auto_Loan_Application__c] < 2017-10-31) 

And that is not returning any results - am I missing a step?

  • 1
    try putting single quotes around the dates. If that doesn't work, make sure that the date you are comparing it to is in the same format as the date you are pulling from your DE. Dec 12, 2017 at 20:09

1 Answer 1


The format for dates in SOQL is: 2016-03-17T12:00:00.000+0000

I believe this is stored as UTC time.

Also, I don't think you need the [].

Try: (acc.Most_Recent_Auto_Loan_Application__c > 2017-08-01T00:00:00.000+0000 AND acc.Most_Recent_Auto_Loan_Application__c < 2017-11-01T00:00:00.000+0000)

I think the required format depends if the field is defined as a date or a date/time. The format I provided is for date/time.

  • 3
    This is a Marketing Cloud question. Dec 12, 2017 at 22:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.