Calculate months between today or now and a date field

[jmalenfant]

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!

[sunny_talwar · Accepted solution]

May be this

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

[jmalenfant]

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