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