Where Statement with SQL Server Using Dates

[DavidArchibald]

Ahhhhhh, another fool who is struggling on this old chestnut!

I have a Datetime field in a SQL Server 7 table with a valid date in US format eg 9/25/2002.

The ASP/web server converts this to UK format (our locale format).

Even when I convert the date to US format, the recordset is empty.

SOO, what's the simplest way in the above scenario to do the following -

SELECT * FROM table_name WHERE table_field = date

Thanks in advance.

 

[snowboardr]

try:

strSQL = "SELECT * FROM table_name WHERE table_field ='" & date & "'"

or

strSQL = "SELECT * FROM table_name WHERE table_field ='#" & date & "#'"

or

strSQL = "SELECT * FROM table_name WHERE table_field ='" & month(date) & "/" & day(date) & "/" & Right(year(date),2) & "'"


one of those should work for you..

- Jason



www.vzio.com
ASP WEB DEVELOPMENT

 

[DavidArchibald]

Bingo!

First time.

Thanks for your help.