Forum Discussion

MannyPinheiro1's avatar
MannyPinheiro1
Qrew Trainee
6 years ago

How to prevent negative values from being displayed

Hello I am working on a Table field where I am calculating the number of days that have passed since the date entered in another date field "Date of Release".  This formula seems to work great: ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
try this

var date EndDate = Today();
var number DaysFromEndDate = ToDays($EndDate - [Date of Release]);

IF($DaysFromEndDate>=0, $DaysFromEndDate)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MannyPinheiro1's avatar
MannyPinheiro1
Qrew Trainee
6 years ago
Thank you Very much Mark!

------------------------------
Manny Pinheiro
------------------------------