How to search records by date in the JS SDK?
Does anyone know if it's possible to search records within a date range via the JS SDK?
the COQL query I have working is (changed for legibility) :
- SELECT Name FROM Leads where (Created_Time >= fromDateTime and Created_Time <= toDateTime and Resource = resourceID)
I'd like to be able to execute this same query via the JS SDK but this doesn't work:
- ZOHO.CRM.API.searchRecord({Entity:"Leads",Type:"criteria",Query:"((Created_Time >= fromDateTime and Created_Time <= toDateTime and Resource = resourceID))"})
- .then(function(data){
- console.log(data)
- })
Looking through the docs at:
there doesn't seem to be a way to search within a date/time fields?