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)?
  • 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.
  • 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)
  • DangThai's avatar
    DangThai
    Qrew Trainee
    7 years ago
    made it work
    var number DaysOverDue = Min(90, ToDays(Today()-[Date Received])); 
    If($DaysOverDue > 60, $DaysOverDue - 60)
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    OK, Very good.
  • DangThai's avatar
    DangThai
    Qrew Trainee
    7 years ago
    Thank you for your help good sir!