How would you show how many days left until a certain date is reached?
It feels like an equation of
Future date - current date= days left.
I am trying to show a countdown to a deadline on clients' projects, so every time the client record is viewed you can see this countdown.
p.s I am still trying to get the system to display a future date, where the deadline is 120 days from the client becoming a client.
This page explains what you need
https://support.knack.com/hc/en-us/articles/115003882107-Numeric-Equation-Functions
To calculate a future date that is 120 days from client becoming a client:
ActiveStartDate is a date field that contains the specific date.
Then use a date equation to generate the future deadline date 120 days from start.
{ActiveStartDate} + 120
Then use a Numeric Equation as follows to generate remaining days from currentDate to the Future Date:
({FutureDate} - currentDate()) / 86400000
If future date is before current date, the result will be negative. Then just use a conditional display rule to hide result if needed.