Calculating time (in Months) between two dates
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... :-/