How to get Month difference by formula

HCL Domino Domino Forum
1

hi,i am having a field “billstart_d” it is date field, and i will enter number of months in two field , it is number field, what i want is i want the difference in month.

some time i used to enter decimal also.

i am not getting correct answer. any idea.

my code:i am using it in acomputed number field.

@Adjust(billstart_d;0;(offprod_n+onprod_n);0;0;0;0))

billstartdate_d is a date field

offprod_n and onprod_n r number field.

regds

soma

2

Subject: how to get Month difference by formula

@Month(billstart_d) will return a number where january=1, february=2 etc.some easy maths will give you the difference between the month entered in your number field and this one.