How to get passed time in months from two dates?

Here is one way. Not as clean as Excel but it works:

let sYear := year(Date1);
let eYear := year(Date2);
let numYear := if eYear > sYear then eYear - sYear else 1 end;
let sMon := month(Date1);
let eMon := if eYear > sYear then
        month(Date2) + numYear * 12
    else
        month(Date2)
    end;
eMon - sMon

Lines 1 - 4 takes two date fields (Date1 and Date2) and breaks out the year and month number from the dates.

Lines 5 - 9 has to add a bit of math to account for months in the next year. The if statement check if  eYear is greater than sYear and if it is then it takes the number of years from line 3 and multiplies it by 12 then adds the month number in Date2

Line 10 then does the easy math of subtracting sMon from eMon getting you the number of months between the two dates.

Cause I can't leave well enough alone. The code can be cleaned up to:

let sYear := year(Date1);
let eYear := year(Date2);
let numYear := if eYear > sYear then eYear - sYear else 0 end;
let sMon := month(Date1);
let eMon := month(Date2) + numYear * 12;
eMon - sMon

There is no check if the eYear is less than sYear.

Fred Way to go man. You just solved a problem for me to that I did not know I had.

Just got asked this week by one of my team - if I could add the facility to calculate when a customer orders a repeat job - How long was it since they ordered the last occurrence.

Hadn't even got around to looking at it.

Your script is perfect - Thanks buddy :-)