If I read your formula correctly, it looks like you're 1st subtracting one

date from another (which yields days) and then using the month function on

the result, and then subtracting 1. This is a meaningless calculation. As

others have suggested, use the DateDiff() function. Or you could roll your

own with something like (air code):

Month(date1) - Month(date2) + (Year(date1) - Year(date2)) * 12

Fred

"MMFBprez" <tm******@mmforward.com> wrote in message

news:26**************************@posting.google.c om...

I am trying to compute storage charges by getting the number of months

between dates and multiplying it by a rate. I cannot get a correct

number of months if the date is greater than a year ago. Here is the

formula I am using now to get the number of months: #ofMonths:

Month([dbo_tblOutBoundTrackingHeader].[closedate]-[dbo_tblInboundTrackingHea

der].[createdate])-1. It has worked for me until now because it never was greater than a

year before. Please help. I am a novice at this.