Recent content by DJaftha

Hi arnelgp, the 10% is only added once the grace period expired after the licence expiry dated, like 23 of February.

Hi theDBguy, thanks for your attention to this. The policies around licence renewal is that once a vehicle licence expires, the owner has 22 days grace to update the licence and then from the 23 a penalty for the whole month will be added at 10% of the annual fee. e.g. Vehicle expires the 31...

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...