I need No of Months after subtracting one date from 2nd dat

justicevb · Post by **justicevb** » Wed Jan 07, 2009 2:18 am

I need to find Number of months after subtracting one date from other date,
Please find the requirement below

NUMBER OF MONTHS (MOAT_DT - TODAY())

I need the result of Number of Months after subtracting TODAY() date from MOAT_DT

Plesae suggest me regarding this.

Thanks in advance
vb

Pierre · Post by **Pierre** » Wed Jan 07, 2009 2:25 am

Can you describe the result you expect ?

I mean, if today is 2009-01-07 and previous date is 2008-12-06, do you expect 1 or 2 months ?
And if today is 2009-01-07 and previous date is 2008-12-08, do you expect 0 or 1 month ?

And so on...

Pierre.

yousuff1710 · Post by **yousuff1710** » Wed Jan 07, 2009 4:59 am

Use function DaysSinceFromDate & then divide by 30.
Take o/p column in integer type.
You will get the required o/p, I guess.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 07, 2009 5:09 am

Never re-invent the wheel where you don't need to. For example a set of date arithmetic functions can be had from here

chulett · Post by **chulett** » Wed Jan 07, 2009 8:01 am

yousuff1710 wrote:Use function DaysSinceFromDate & then divide by 30.

Not in a Server job.

chulett · Post by **chulett** » Wed Jan 07, 2009 8:03 am

As noted, the answer will depend on your definition of 'month' when computing the number of months between dates. If your definition aligns with Ray's then you're all set.