-
Access 97 and DateAdd() function in stored procedure
I'm trying to retrieve any rows added in the past week and using the Query Builder in acc97 gave me this...
SELECT quickLists.quickListID, quickLists.listTitle, quickLists.listSource, quickLists.numItems
FROM quickLists
WHERE (((quickLists.dateCreated)>DateAdd("ww",-1,Now())));
The error that appears when I display my ASP page is this ...
---------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Unknown function name in query expression '(((quickLists.dateCreated)>DateAdd("ww 4;,-1,Now())))'.
---------
Am I just not able to use the DateAdd function in a query of this type? And if not, why is it provided for in the querybuilder? And, one last question, what would be a solution to what I need to do?
Matte Edens
Web Producer - KNTV NewsChannel 11 / KBWB WB20
webmaster@kntv.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|