Dear All,
I would like to create a form with a date field (name Due_Date) and a formula.
My scenario:
When I give a date to the date field (for example 22/7/2015) then I would like in the formula field to calculate the
date (22/7) - zoho.currentdate and to return me the number of days.
In the report, each day the zoho.currentdate will decrease the number of days by 1.
In that case I wrote the following inside the formula:
days360(Due_Date,zoho.currentdate)
The problem is that in the report it does not change the number of days (-1) every day. What am I doing wrong?
In general is there any way a number (in a report) to decrease by one every day?
Like the overdue days in the Zoho Invoices report for example which increase every day by 1!!