Built in Search, Last n Days not including Today

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.