|
-
September 2nd, 2001, 07:33 PM
#1
GETDATE()
i have a database program and i need to print a query when a certain time lasp has accurd in a date length...
i creadted a search query and in the required field i put in the criteria of
from (orderdate >= DATEADD(day, -5, GAETDATE()))
when i run the query i get and error
undefined function 'getdate' in expression
also after i create this and get it working how do you run a query from a command button..
midnightservice
thanx in advance
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
|
Click Here to Expand Forum to Full Width
|