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 |
|
prettyjenny
Yak Posting Veteran
57 Posts |
 Posted - 2009-11-27 : 09:45:32
|
| Hello,I tried to run the ASP script with the same script for both Access and SQL Server. Access database works fine. SQL server database don't work and shows the syntax error. I think DateSerial causes this error.How do I change the query and make it work?student_dob >=#" & DateSerial(yr(3), mo(3), 3) & "#Thanks very much!There is no stupid question.Asian Girls at Free Online Dating |
|
|
duncanwill
Starting Member
20 Posts |
Posted - 2009-11-30 : 10:30:51
|
| The # delimeter is only used for access dates - not for SQL. Try:student_dob >='" & DateSerial(yr(3), mo(3), 3) & "' |
 |
|
|
|
|
|
SQL Server error 80040e14 -DateSerial