Forum Discussion

DangThai's avatar
DangThai
Qrew Trainee
7 years ago

How to Calculate Fees Incurred Daily from [Date Received]

I'm looking for a more elegant formula to calculate fees incurred after a certain date, then daily up to 30 days. Below is what I've put together; is there a shorter way of expressing this?" "If(ToDa...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Try this

var number DaysOverDue = ToDays(Today()-[Date Received];

If($DaysOverDue > 60, $DaysOverDue - 60)
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
No problem

var number DaysOverDue = Min(30, ToDays(Today()-[Date Received]);

If($DaysOverDue > 60, $DaysOverDue - 60)

// the formula above will use the smaller of 30 and the # of days overdue.