Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a table with the field OpenDate and i'd like to know how many months have passed between that date and today, can anyone suggest a formula?
Hi,
i think you meant something like that:
...
num(month(now())) - num(month(OpenDate)) + (year(now()) - year(OpenDate))*12 as monthDiff
or absolut
fabs(num(month(now())) - num(month(OpenDate)) + (year(now()) - year(OpenDate))*12) as monthDiff
...
Best
Sacho
Hi,
i think you meant something like that:
...
num(month(now())) - num(month(OpenDate)) + (year(now()) - year(OpenDate))*12 as monthDiff
or absolut
fabs(num(month(now())) - num(month(OpenDate)) + (year(now()) - year(OpenDate))*12) as monthDiff
...
Best
Sacho