Re: dates

From: Silicon Knight <SiliconKnight_at_hotmail.com>
Date: Mon, 7 Jun 1999 11:06:57 -0400
Message-ID: <0bR63.15$1r3.382@otma3.state.de.us>

Thanks to all! I got it to work. The 'date' needed to be #date#

tim

Silicon Knight <SiliconKnight_at_hotmail.com> wrote in message news:Kof53.11$1r3.431_at_otma3.state.de.us...
> I am trying to do a select on tables based on dates and I can't get it to
> work.
>
> ex.
>
> select * from table where initial_date < '01-Jan-99' and final_date >
> '01-Jan-99';
>
> any idea why this doesn't work?
>
> Thanks in advance,
>
> Tim
>
>
Received on Mon Jun 07 1999 - 10:06:57 CDT