datediff?

Noget i denne stil:

SQL = "select * from hejsa where dato > #" & datediff("h",Now,-1) & "#"

Sorry:

SQL = "select * from hejsa where dato > #" & dateadd("h",-1,Now) & "#"

hvad brugrs # til

cheat_sql="select ip from ex_ip where site_id='"&sid&"' And ip='"&cl_ip&"' And dato > #" & dateadd("h",-1,Now) & "# ORDER BY id DESC"´

sådan her ser min syntax ud

den siger


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '09'.
/netstars/nex/go.asp, line 26

Sorry - jeg troede det var på en Access. På MS SQL-server skal # skiftes med '

cheat_sql="select ip from ex_ip where site_id='"&sid&"' And ip='"&cl_ip&"' And dato > '" & dateadd("h",-1,Now) & "' ORDER BY id DESC"´

takker