Calculate months between today or now and a date field

jmalenfant — Sat, 16 Nov 2024 21:16:44 GMT

Hi all,

I've been researching the support and community forums but am stuck with what I think is straightforward issue.

I need to calculate the # of months (or weeks or days, depending on project) to determine how many months from now (current date) until the END_DATE field for a list of contracts

I've been able to calculate the # of months in a project from start to finish dates with this code and have tried to modify it several ways but can't get the syntax right for the equation END_DATE - current date output in months

((year([End Date])*12)+month([End Date])) - (((year([Start Date])*12)+month(Date#([Start Date]))))

Any help greatly appreciated!

Re: Calculate months between today or now and a date field

sunny_talwar — Fri, 08 Mar 2019 17:54:56 GMT

May be this

(
  (Year(END_DATE)*12) + Month(END_DATE)
)
-
(
  (Year(Today())*12) + Month(Today())
)

Re: Calculate months between today or now and a date field

jmalenfant — Fri, 08 Mar 2019 17:58:04 GMT

thanks SO much! I knew it had to be simple 🙂

topic Re: Calculate months between today or now and a date field in App Development

Calculate months between today or now and a date field

Re: Calculate months between today or now and a date field

Re: Calculate months between today or now and a date field