AnsweredAssumed Answered

Calculating time (in Months) between two dates

Question asked by ZiteMedia on Mar 19, 2014
Latest reply on Mar 19, 2014 by philmodjunk

Title

Calculating time (in Months) between two dates

Post

     Hello,

     I'm trying to figure out the correct formula which should give the number of months that remain between "today" (or CurrentDate?) and a date in the future (from another field  "contract_end_bup").

     Clearly, this formula     "Month ( contract_end_bup ) - Month ( Get ( CurrentDate ) )"      is not the way to go, as it only gives me the correct result as long as the two dates are within the same year.

     Would be great if someone could help me out as i'm really stuck on this one...  :-/

     Much appreciated!

Outcomes