Last paid, next payment due calculations

[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