Hey all,

I've been searching for hours and I can't find the answer.

I need to update existing records with today's date through ASP into a SQL 2005 Express table

If I do the following on via opening a recordset...

strSpotlightQ = "update artistspotlight set displayDate2 = '1/26/2008'"

rsSpotlight.Open strSpotlightQ

It works. The field "displayDate2" is a date field in the SQL table, but it also works on "displayDate" which is a character.

My problem is that I want my ASP program to determine what the date is.

strSpotlightQ = "update artistspotlight set displayDate2 = " & date()

It won't work. This sounds dumb, but even if I put quotes around it it won't work. Even if I use cdate(date()) it doesn't work.

Can anyone please tell me how the heck to update the date in SQL 2005 through ASP?

This is mighty important.

Thanks
DonnaZ

use single quotes for dates in MS Sql

column = '" & date() & "' ;"

or use the SQL date function

... column= date() ;"

or a convert()

column = CONVERT(datetime," & date() & ") ;"

Use single dates. Its not so hard mate.

Originally Posted by Amirmullick3

Use single dates.

And that means?

Originally Posted by chrishirst

use single quotes for dates in MS Sql
column = '" & date() & "' ;"
or use the SQL date function
... column= date() ;"
or a convert()
column = CONVERT(datetime," & date() & ") ;"

Donnaz,

Sql date function Or Convert function should work. Make sure to remove semicolon from query.

Make sure to remove semicolon from query

Why would you do this?

or rather

Why do you think semicolons should be removed?

Update Table Set Column = GetDate()

Or

Update Table Set Column = GetUtcDate()


Also, are you really trying to open a result set from an update query?

does NOW() not work? i could be wrong

Matt