Hello,

I am working on a Zoho CRM formula to calculate the remaining days from a Due Date field. My goal is to display the number of days left from today to the Due Date.

I have tried the following formula, but it is not working as expected:

plaintext
CopyEdit
if(isNull(${Alerts.Due_Date}), null, dateComp(now(), ${Alerts.Due_Date}) / 1440)

What I Need:

• If the Due Date is filled, the formula should calculate the number of days remaining.
• If the Due Date is not filled, the formula should return null or leave the field blank.

I've also tried using dateDiff and date(), but I still cannot get it to work. Can anyone guide me on how to correctly use dateComp() or any other suitable function to achieve this in Zoho CRM?

Thank you in advance for your help!