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)
DangThai's avatar
DangThai
Qrew Trainee
7 years ago
Sorry, it's not giving me the calculation I'm looking for. Even added the ) to the
var number DaysOverDue = Min(30, ToDays(Today()-[Date Received])); 

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