Forum Discussion

DangThai's avatar
DangThai
Qrew Trainee
6 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
Try this

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

If($DaysOverDue > 60, $DaysOverDue - 60)
DangThai's avatar
DangThai
Qrew Trainee
6 years ago
Thank you for your help good sir!