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.
| Author |
Topic |
|
genic
Yak Posting Veteran
57 Posts |
 Posted - 2001-03-12 : 10:57:30
|
| i am trying to use a date range to query for records within that range. likeselect b.hours, b.workdate from profile as a inner join projecttime as b on (b.profileemail = a.profileemail)where b.profileemail = 'email@meail'and b.workdate between '3/1/01' and '3/12/01'the problem i run into is this. the date field is a varchar datatype and when i try the query it only gives me the record for:hours workdate 8 3/1/018 3/12/01however i KNOW i have a record for each day within that range. 3/2/01, 3/3/01..etc.however it will not select these. help?ps. i can not change the data type to a datetime one because of formatting issues in the past. a uniform date is now being used but i can not conver the old records. |
|
|
|
|
|
between date range..receiving dates outside