Re: FORMS4.5:query between dates?
From: Ranju Sinha <ranju_at_worldnet.att.net>
Date: 1997/08/16
Message-ID: <01bcaa74$0ec12b00$418674cf_at_default>#1/1
Date: 1997/08/16
Message-ID: <01bcaa74$0ec12b00$418674cf_at_default>#1/1
In the forms designer make the query length of the datae column as say 100 and while making a query (i.e. in enter-query mode type in #between '01-JUN-97' and '01-JUL-97'
Have fun.
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 Sat Aug 16 1997 - 00:00:00 CEST