Need help finding records by date (error 4500)
Hi!
I have a simple code:
- records = zoho.crm.searchRecords("CustomModule3", "(Last Activity Time|like|*"+Today+"*)",1,1);
- info records;
I want to find one last modified entry. Why do I always get an error in the request?
Why does not he search the date field?
I tried this
- thisMonthStartTime = toStartOfMonth(zoho.currentdate).toString("yyyy-MM-dd");
- query = "(Last Activity Time|contains|*" + thisMonthStartTime + "*)";
- records = zoho.crm.searchRecords("CustomModule3", query, 1, 1);
- info records;
and this
- thisMonthStartTime = toStartOfMonth(zoho.currentdate).toString("yyyy-MM-dd HH:mm:ss");
- query = "(Last Activity Time|like|*" + thisMonthStartTime + "*)";
- records = zoho.crm.searchRecords("CustomModule3", query, 1, 1);
- info records;
And I tried to look for other dates fields. Its don't working...
The date is stored in this form - "Last Activity Time":"2017-10-02 16:25:09"
Why can not I find this date ???
This only works when I do so:
- records = zoho.crm.searchRecords("CustomModule3","(Last Activity Time|=|2017-10-02 16:25:09)",1,1);
- info records;
Why??