Built in Search, Last n Days not including Today
I'm seeing a strange behavior using the built in search option on date fields.
This is a field that I populate through the Zoho API.
If I choose any of the available "Last n days" date range functions, i.e. Last 7 days, Last 30 days, the view does not include records with today's date.
The "Today" option returns today's records.
The field uses the following format: yy-mm-dd hh:mm:ss
I have not tested other formats to see if it is specific to this one.
Update:
After looking at the code zoho generates when the view is saved "(Sent >= (zoho.currentdate - '1W:0D:0H:0M:0S') && Sent <= zoho.currentdate)" where Sent is the date field,
I modified it to this:
Sent >= (zoho.currentdate - '1W:0D:0H:0M:0S')
and it works.