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

[sathishkumar_go]

Hi Arun,

AUTHDATE field format is 02APR2002:14:28:25

can u try this date(date#(AUTHDATE,'DDMMMYYYY HH:MM:SS'),'DD/MM/YYYY') AS AUTHDATE

ONCE U GET DATE FORMAT THEN ITS EASY

-Sathish

[spsrk_84]

Hi,

i have q quick question here whether you are loading the data from database or qvd?

Suppose if you are loading data from database then first fetch the data as it is i mean don't go for any calculations and store the the data in to qvd ...

then you can do the calculations while fetching the data from qvd..

Regards,

Ajay

[#4]

Thanks,

it really work fast !