Last paid, next payment due calculations

[Kirsty]

Hi,

I have a scenario where I need to record:

The last paid date

Next payment due, which will be based on a calculation from the last paid date

=last paid date plus one month
=last paid date plus three months
=last paid date plus twelve months

I also need the last paid date to automatically update. So as example if something was paid on 01st September 22, the next payment date (if last paid date plus one month) would be 01st October 22. Who the 1st October has passed, I need the database to automatically update the last paid date to 1st October 22 and so on

[Sunny_Singla]

Solution for adding months to a date (native Knack features)

I recently had the need to add months (1, 2 or 6) to a date. As per previous topics there is no obvious way to do this in Knack, due to the complexities of different length months and leap years, and the absence of a function to add months to a date. Some examples of what we are trying to achieve are below: 15 Jan 2022 plus 1 month should be 15 Feb 2022 31 Jan 2022 plus 1 month should be 28 Feb 2022 31 Jan 2024 (leap year) plus 1 month should be 29 Feb 2022 There’s a surprising way to do t…

Plz check this