QUERY FOR GETTING DATA BETWEEN TWO DATES

[selimsl]

Hi!

I have a table, which has following fields.
date_cs
data_cs
The type of date_cs is date
The type of data_cd is integer
I need a query to extract data between two dates
I guess this query can be like this:

select data_cs from table_name date between ?????

Thanks in advice

 

[DotNetGnat]

something like this:

select data_cs from table_name date_cs between #08/01/2005# AND #08/31/2005#

above is just an example...

-DNG

 

[DotNetGnat]

oops..i missed the WHERE key word

select data_cs from table_name WHERE date_cs between #08/01/2005# AND #08/31/2005#

-DNG

 

[selimsl]

I need to extract data between two dates,but with clock information.
Like this;
I need to extract data between 08/01/2005 12:00 and
08/31/2005 15:00

thanks in advice

 

[PHV]

BETWEEN #2005-08-01 12:00# AND #2005-08-31 15:00#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886