Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SunukrishSunukrish 

how can we retrieve opportunities that are modified in last 15 mins without using apex code but only via soql?

How can you we retrieve opportunities that was modified in last 15 mins without using apex code but via soql only,
Vamsi KrishnaVamsi Krishna
I m not sure if you can directly do that in SOQL,
but one option is to have a formula datetime field in your object which will give the time difference and then you can use the field in your SOQL query...
Vyacheslav Ramazanov 6Vyacheslav Ramazanov 6
SELECT Id FROM Opportunity WHERE LastModifiedDate >= YYYY-MM-DDThh:mm:ssZ

Where YYYY-MM-DDThh:mm:ssZ is the time 15 minuts before now