Months caluculation

[#1]

Dear All

Book Date	Today	Diff Months
26/12/2008	26/12/2011	36
26/12/2009	26/12/2011	24
26/12/2010	26/12/2011	12
26/9/2011	26/12/2011	3

I want to caluculate Diff in months please  help me with  backend script

[rohit214]

hi

try this

in script

num(month(BookMonth) as BookMonth,

num(Month(today() ) as taday,

or

num(Month(today() ) - num(month(BookMonth) as Diff

in expression

today-bookMonth

may it helps you

thanks

rohit

[SunilChauhan]

try this

interval(Today- BookDate,MM)

[Clever_Anjos]

LET d1 = today();

LET d2 = '01/02/2005';

LET MonthsBetween = year(d1)*12 - Month(d1) - (year(d2)*12 - Month(d2));

[#5 · Accepted solution]

Hi,

((Year(BookDate)-Year(Today()))*12)+(Month(BookDate)-Month(Today())) as [Month Diff]

You can see also the attach qvw.