Forum Discussion
QuickBaseCoachD
Qrew Captain
Try this
var number DaysOverDue = ToDays(Today()-[Date Received];
If($DaysOverDue > 60, $DaysOverDue - 60)
var number DaysOverDue = ToDays(Today()-[Date Received];
If($DaysOverDue > 60, $DaysOverDue - 60)
DangThai
6 years agoQrew Trainee
made it work
var number DaysOverDue = Min(90, ToDays(Today()-[Date Received]));
If($DaysOverDue > 60, $DaysOverDue - 60)
var number DaysOverDue = Min(90, ToDays(Today()-[Date Received]));
If($DaysOverDue > 60, $DaysOverDue - 60)