Sorry didn't notice it before you hace "where where" in your statement which
is your error

-----Original Message-----
From: Alastair Ramsay [mailto:aramsay@h...]
Sent: 22 June 2001 10:50
To: sql language
Subject: [sql_language] RE: error date



Hi Himanshu

Try this

sqlss="select distinct[smsto] from smsto where WHERE
dates>=>DateAdd("h",-1,Now())"

Alastair Ramsay

-----Original Message-----
From: Himanshu Chaudhari [mailto:himanshuchaudhari@y...]
Sent: 21 June 2001 13:09
To: sql language
Subject: [sql_language] error date


hi,
 
I have to retrive data from the access database which
is only one hour old. i.e. updated data in last one
houe . I am  writing:

redate=now()-1/24
sqlss="select distinct[smsto] from smsto where WHERE
dates>=#"& redate &"#"


but the query is giving error :

Microsoft OLE DB Provider for ODBC Drivers error
'80040e14' 
[Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression 'WHERE
dates>=6/21/01 4:22:54 PM'. 

    What can be possible error in the query .
 
                          Himanshu