Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sql to get data between a start and end date

Author  Topic 

hs
Starting Member

1 Post

Posted - 2002-07-16 : 01:31:51
How to write an sql to pick the data between a given Start and End Date in SQL SErver using VB



Can some one give me an example of this please.

I tried the following without any results.

Select * from qry_meet where convert(datetime,DateTimeOfConf,103) between 1/1/2000 and 1/1/2002

chadmat
The Chadinator

1974 Posts

Posted - 2002-07-16 : 01:47:38
try putting your dates in singlequotes.

-Chad

Go to Top of Page
   

- Advertisement -