Select statement and Dateadd

[tcapp]

I am trying to select only records for the next seven days. I have added a date in the record using the DTpicker. When using the dateadd function in my SQL statement it gives me a syntax error. Any help is appreciated.

Code:
edate = DateAdd("d", 7, Date)
' set strings
sSQL = "select [Assigned To],ClientID,Comments,DueDate,ProjectTitle,RecordID,Resources,Submittal from HotList where duedate >= '" & edate & "'"

 

[woyler]

What is the error? Is the data type in your database for [duedate] a string or Date/Time? And what database are you using(SQL Server,ORacle,ACCESS)?

 

[tcapp]

Thanks I figured it out from a previous post... What I was looking for was

sSQL = "select [Assigned To],ClientID,Comments,DueDate,ProjectTitle,RecordID,Resources,Submittal from HotList where duedate between #" & Date & "# and #" & edate & "#"

I wasnt using the #