I am trying to use two fields to use Btree.Extract to obtain

record keys. I am able to get the Search.String to work when I

hardwire the select data to a fixed date. I am trying to obtain

data narrowing the select by obtaining dates ] a given date.

I got it to work with the operator and a fixed date. As my code

shows I want a dynamic date…Jim

¦DATESHIPPED=OCONV(DATE() - 71,"D2-")

¦OPERATOR=]"

¦DATEPREF=OPERATOR::DATESHIPPED ¦*DATESHIPPED=OCONV(DATE() - 71,"D2-") ¦DATE=OCONV(DATE(),"D2-") STRING=SUPPLY_NO':@VM::RECNO:'':@FM:"DATE_SHIPPED":@VM: ':DATEPREF:':@FM

RECNO and DATEPREF are variables they should not be enclosed in quotes in your STRING=… line of code

To find a date GE a given date, you can either OCONV an ending date, such as 1/1/2002 and put it as 01/01/2000~01/01/2002 (between the @VM marks)- the tilde forces the RANGE function for BTREE.EXTRACT or try a GE like: @VM:]=01/01/2000":@VM

I think the ]= works, as the # sign works to exclude values.

[email protected]

If you are wondering why this code doesn't work, it may be because ":RECNO:" and ':DATEPREF:' are constant text strings rather than the variables you are loading.

View this thread on the forum...