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.
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.
Topic Participants
boley
Ruben Kannan
Herb Wexler
Motivate
Christopher Cantrell
Sticky Posts
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. CharlesMerge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around