|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
