Using GETRANGEMAX

johndim

Hi everybody
I have a record variable for "Purchase Line" table and i want to find
specific records for an item.
I use setrange to find all records for that item but my problem is when i get more than one record in return. I want to get the record with the biggest value in the "Expected Receipt Date" field.
I tried GETRANGEMAX with SETFILTER like this :

EVALUATE(jd,'311206');
recPurchaseLine.SETFILTER(recPurchaseLine."Expected Receipt Date",'%1..%2',0D,jd);
myDate := recPurchaseLine.GETRANGEMAX(recPurchaseLine."Expected Receipt Date");

But in the end the value of myDate variable is 31/12/06 (which is the upper limit of my filter) and not the biggest value of my record.

What is wrong ... please help ](*,) ](*,) ](*,)

DenSter

What I would do is probably find a key with both the Item number and the expected receipt date, use that key in a SETCURRENTKEY, and do a FIND('+').

Kowa

This post is about finding minimum values :
http://www.mibuso.com/forum/viewtopic.p ... highlight=

In the different methods,use Find('+') or ASCENDING(FALSE) to find the largest value.

johndim

Thanks guys it finally worked
i used a key and find('-')

Thank you All. \:D/ =D>