Re: FORMS4.5:query between dates?

 Edward,

You should try to avoid hard coding the two dates. Instead assign variables with type date and intialize them with a value like

today DATE := sysdate;

if :block.date between today AND someother date THEN
      do something

end if;

Cecil

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 Wed Jul 30 1997 - 00:00:00 CEST