Dear Zoho CRM Team and Users,

We have contracts with our clients from 1 - 12 months. 

So we have the following fields:

Start Billing ( date field )

End Billing ( date field )

And the team requested the following field:

Remaining Contract Days ( formula field )

However to pull this off I had to create a new custom field called Current Date ( date field )

So that I could use an equation in the formula field to get the total remaining days of the contract, however it would be nice if the formula field could use the system variable zoho.currentdate in the equation rather than the Current Date field. As I had to create a third field called:

Recalculate Remaining Contract Days ( check box )

So that I could trigger the workflow to run the custom function to get the current date to be added to the Current Date custom field.

 

In the custom formula field Remaining Contract Days I am using the following formula:

Datecomp(${Accounts.End Billing},${Accounts.Current Date})/60/24

However, it would be very helpful if I could change this formula to the following:

Datecomp(${Accounts.End Billing}, zoho.currentdate)/60/24

However, this system variable is not valid in a formula field.

Any one have any thoughts on having this functionality available?

Thanks,

Thomas Pursifull