|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Help with SQL statement |
|
From: |
derek |
|
Date: |
5/4/2001 5:15:55 PM |
|
IP: |
192.216.170.69 |
I am having trouble with using comparison operators with date fields on a SQL server 7 database.
The following code is giving me errors:
Dim strSql
strSql = "SELECT * from tblTable WHERE dtDateField < #" & FormatDateTime(Now,2) & "# "
I've tried changing the # to single quotes but that is telling me that text field types can't be used with the WHERE statement.
Does anyone know how to use comparison operators (> , <, >= , <= , = ) with Date field types?
Please help...
--frustrated
|
Follow Up - Re: Help with SQL statement - Atul Patil 5/5/2001 12:50:48 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
