Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
((Year(BookDate)-Year(Today()))*12)+(Month(BookDate)-Month(Today())) as [Month Diff]
You can see also the attach qvw.
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
try this
interval(Today- BookDate,MM)
LET d1 = today();
LET d2 = '01/02/2005';
LET MonthsBetween = year(d1)*12 - Month(d1) - (year(d2)*12 - Month(d2));
Hi,
((Year(BookDate)-Year(Today()))*12)+(Month(BookDate)-Month(Today())) as [Month Diff]
You can see also the attach qvw.