Hello all,
I am attempting to do a supertool extract and have run into a stumbling block.
All I want to do is extract records that fit in a specified date range. The
dates on the records are in YYMMDD format and the date range crosses the
century. The following is the code I thought would work but I didn't receive
any 2000 data. Any help would be appreciated. *Please respond direct since I
receive the digest version of this list.
!SUPRTOOL
BASE = SADB.DB.IPI
GET STOCK-ACTIVITY
ITEM DATE-INV-ACT,DATE,YYMMDD
SET DATE CUTOFF 50
IF $STDDATE(DATE-INV-ACT) >= 19990401 AND &
$STDDATE(DATE-INV-ACT) <= 20000401
OUTPUT OUTPUT0
XEQ
Thanks in advance,
Jeff Keepers