Problem in Specifying a Date Range

[Devaki]

Hi,

Can anyone help me to find out the problem with this Query that has a date range.

Select a.containername,a.containerid,a.thiscontainerlost,a.status from Container a, ContainerLevel b where a.levelid = b.containerlevelid And a.containername <> a.containerid And b.Containerlevelname = 'Wafer' And
(a.originalstartdate >= '3/1/02' And
a.originalstartdate <= '3/22/02')

I am executing this query through VB and my database is in Oracle.

Thanks
Devaki

 

[SkipVought]

Do you think that it might want year as 4 digits? Skip,
metzgsk@voughtaircraft.com

 

[CasperTFG]

If you database is in Oracle, you might need to do this...

Select a.containername,a.containerid,a.thiscontainerlost,a.status from Container a, ContainerLevel b where a.levelid = b.containerlevelid And a.containername <> a.containerid And b.Containerlevelname = 'Wafer' And
(a.originalstartdate >= #3/1/02# And
a.originalstartdate <= #3/22/02#)

and don't forget ;
Craig, mailto:sander@cogeco.ca
&quot;Procrastination is the art of keeping up with yesterday.&quot;
I hope my post was helpful!!!

 

[Guest_imported]

try using the DD-MON-YY format

 

[Devaki]

hi ,

Both ways does not work. Any other ways to do this?

Devaki