You need to sign in to do that
Don't have an account?
mavs
SOQl BETWEEN
Hi
How do we write sql BETWEEN in SOQL?
We have a table Startdate enddate week 3/12/2010 3/18/2010 12 3/19/2010 3/22/2010 19 If todays date is between startdate and enddate i need week value datetime t = System.now(); date dt = Date.newInstance(t.year(),t.month(),t.day()); some_Object__c temp=[Select week from some_Object__c where startdate__c>=:dt and enddate<=dt];
This is not giving back any results.
Any idea???
All Answers