Calculating the last day of the month or year

Applies to Infiniti v8.0 or later

In some documents, particularly contracts, it is necessary to calculate the last day of the month. This can be achieved by using a formula. There are different ways to calculate this, but the formula below works by finding the first day of the month, adding a month then subtracting a day.

dateadd(4,-1,dateadd(2,1,concat("01/",format([q1],"MM/yyyy"))))

(Replace [Q1] with a reference to your date)
 

Related Articles

 

Keywords

End final dateadd()