If the records are in YYMMDD  format you can not select based on YYYYMMDD
format. You must define a date with the century included and then select
based on your defined dates. I unfortunately do not have SUPERTOOL so I
can't lookup the exact syntax but I'm sure you can find it.

I hope this helps.

-----Original Message-----
From:   HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Jeff Keepers
Sent:   Friday, April 07, 2000 10:50 AM
To:     [log in to unmask]
Subject:        Supertool question

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