Re: FORMS4.5:query between dates?
From: william <willgo_at_erols.com>
Date: 1997/07/31
Message-ID: <01bc9db3$b7d18640$3463accf_at_newmicronpc>#1/1
Date: 1997/07/31
Message-ID: <01bc9db3$b7d18640$3463accf_at_newmicronpc>#1/1
where date_field between 01-jan-97 and 01-jul-97
kathie
edwards_at_garland.dnr.state.sc.us wrote in article
<33DF43E9.63DE_at_garland.dnr.state.sc.us>...
> I've got a simple form with one of the base table items being a DATE.
> I can query all dates greater or less than a given date,
>
> >30-JUL-97
> <30-JUL-97
>
> but how to I query between two dates?
> this doesn't work:
> >01-JUN-97<01-JUL-97
>
Received on Thu Jul 31 1997 - 00:00:00 CEST