Hello All
I have created a "Vehicle Licence Renewal" database and I'm stuck with a query. I need to calculate the penalties and arrear fees in the following way:
Lets say the licence expired the end of January 2020:
If todays date is 23 February then 10% of the licence amount must be added.(From the 1st to the 22nd is a grace period):
If todays date is 01 March then add above for February and (10% + 1/12th for March) must be added to the licence amount and so on for every month after that.
I hope there is simple answer for this (there should be) but my knowledge is very limited w.r.t formulas and vba.
Thank you all for looking and responding
Regards
I have created a "Vehicle Licence Renewal" database and I'm stuck with a query. I need to calculate the penalties and arrear fees in the following way:
Lets say the licence expired the end of January 2020:
If todays date is 23 February then 10% of the licence amount must be added.(From the 1st to the 22nd is a grace period):
If todays date is 01 March then add above for February and (10% + 1/12th for March) must be added to the licence amount and so on for every month after that.
I hope there is simple answer for this (there should be) but my knowledge is very limited w.r.t formulas and vba.
Thank you all for looking and responding
Regards