topic Re: Number of Months between two Dates in App Development

Number of Months between two Dates

qadirm28 — Fri, 17 Mar 2023 20:55:46 GMT

Hello everyone,

I used this formula to calculate the number of months between two dates in a table. But, it shows a negative value, although the last date is higher than the first date.

Month(Date#(Max([Date Meeting]),'YYYY-MM-DD'))-Month(Date#(Min([Date Meeting]),'YYYY-MM-DD'))

Re: Number of Months between two Dates

BrunPierre — Fri, 17 Mar 2023 22:35:05 GMT

Hi, I'd rather you do this.

((Year(Date#([Date Last Meeting Minutes],'YYYY-MM-DD'))*12)+Month(Date#([Date Last Meeting Minutes],'YYYY-MM-DD'))) - (((Year(Date#([Date First Meeting Minutes],'YYYY-MM-DD'))*12)+Month(Date#([Date First Meeting Minutes],'YYYY-MM-DD'))))