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 |
|
patelhasu
Starting Member
13 Posts |
 Posted - 2002-04-19 : 10:59:30
|
| i have this sql statement and i wrote a fucntion that gets the date but now i want to use that function to get a between records for those dates here is the sql statement i'm using ******************************************************************** Me.RecordSource = "Select DISTINCT DEMOGRAPHIC_Full.EthnicCode, DEMOGRAPHIC_Full.Grade, " & _ "EWTransfers.EWWCode FROM EWTransfers INNER JOIN DEMOGRAPHIC_Full ON EWTransfers.EWID = DEMOGRAPHIC_Full.ID " & _ "WHERE 'Between' &((EWTransfers.EWWDate)>='" & Get525Date(1) & "') And (EWTransfers.EWWDate)<'" & Get525Date(2) & "') " ******************************************************************** It does not return any records if i use the Between the way i have it now. Am i missing something Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
between statement