Months Calculation

[#1]

Hi,

I m using the below expression to calculate the months difference

(YEAR(RIGHT(ASOF,4))-YEAR(MID(AUTHDATE,6,4)))*12+(NUM(MONTH(date#(left(ASOF,3),'MMM')))-LEFT(AUTHDATE,2))

DATE FORMAT:

AUTHDATE:
02APR2002:14:28:25

ASOF:
SEP2008

From the Start the Execution execution is fine, there are total 3 crore records. But in the end when it calculates the Difference i.e months using the above expression the system gets completely stuck up. almost passed 10 hrs but still its hanged.

RAM: 64 GB (almost 6 to 7 Users)

pls can any one suggest

Thanks in advance.

regards,

arun