You need to sign in to do that
Don't have an account?
AnonTestQuest
Help with: WHERE Today() <= Expiration_Date__c - 2
I need to have this as my where clause in a SOQL query in Sublime so I only pull records within two days of their expiration date. The custom formula field (expiration date) is a date and the Today() is a system function so it's obviously a datetime and this gives me parsing errors in dev console query editor. Also, what would I put to take 2 days off the expiration date? Would the - 2 work?
WHERE Expiration_Date__c > NEXT_N_DAYS:2
Please check below post. I hope that will help you:-
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
Please let us know if that will help you
All Answers
what is the error in the dev console query editor?
Perhaps you can create a new formua field with your formular and as result you receive true or false. This can be part of your where-statement.
Regards
Robert
(mindforce: http://www.mind-force.de) (http://www.mind-force.de)
WHERE Expiration_Date__c > NEXT_N_DAYS:2
Please check below post. I hope that will help you:-
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
Please let us know if that will help you