Rangemax in Load Script

[#1]

Hi Guys,

I'm having an issue with rangemax in load script where i wish to get max date in multiple dates field.

eg: rangemax(RegisteredDate, Process1Date, Process2Date,.... )

Rangemax works fine in expression but it can't return the max date in load script.

I've tried by changing the dates format to 'YYYYMMDD' , date#(), ...but stil not working.

I push the rangemax to load script part so that i can :

AA Date= Rangemax(A Date, B Date, C Date)

BB Date=Rangemax(D Date, E Date, F Date)

NumDays = AA Date - BB Date

SatisfiedPeriod = ( NumDays <= 20 )

At the end i wish to get total SatisfiedPeriod cases group by Department.

Hope that anyone could solve my problem..

Thanks in advance!

Phoebe Yaw