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
Thank you but it goes on indefinitely. The fee should start at 60 days after date received, incurring $1 a day up to a max of 30 days (90 days after date received)?