Hi,

I’m trying to run the following code, but it returns nothing. I have 4 records where the Next_Date field has the value "OK".

I tried changing the date format to different types, like "2025-01-01", but I still get no results.

Can you help me understand what’s going wrong?

Here is my code:

1. query = "Next_Date:less_than:" + "2025-04-04";//today ;
2. info query;
3. contact = zoho.crm.searchRecords("Obligations",query);
4. api_domain = "https://www.zohoapis.com";
5. url = api_domain+"/crm/v7/Obligations/search?criteria="+encodeUrl(query);
6. info url;
7. res = invokeurl
8.         [
9.         url: url
10.         type: GET
11. connection:"crm"
12.         ];
13. info "res: " + res;
14. return res;
15. }