RE:Date class.

["Jagdeep S. Bedi" <jbedi@palasys.com>]

Ed, Michael

Thanks for the reply...I am using 'where' clauses in my sql to check for a
particular date....
here's my sql:
Select * from GADC where datepart(mm, CR_DATE1)>='03' AND datepart(mm,
CR_DATE1)<='04' AND datepart(yy, CR_DATE1)>='1987' AND datepart(yy,
CR_DATE1)<='1999' AND datepart(dd, CR_DATE1)>='02' AND datepart(dd,
CR_DATE1)<='21'
this searches my databases for 'dates' between 3/21/1987 - 4/2/1999 (as
string values)...but, problem is that it misses one date in my
database...1/6/98...clearly this date falls between my range...but the
criteria i set up does not include it...any ideas...on how to include it
with my current method

thanks again