Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Stored procedure to filter records between getdate() minus 1-3 months
I'm trying to create a stored procedure to display the records in an incident database for the last 30, 60, or 90 days. I have tried "Between Date( ) And DateAdd("M", -1, Date( ))" but the access projects gives me the error "ADO error:'Date' is not a recognized function name." I tried...- ebic
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
-
Funky date in ADP (7-digit year)
I was called in to investigate a problem with the date display in an ADF file. When I viewed the information I saw a date formatted like 01-Nov-2007227. I closed the form and opened up the table to view the information directly, sure enough all the dates were formatted similarly. I closed the...- ebic
- Thread
- Replies: 3
- Forum: Microsoft: Access Project (ADP)
-
Parameter query and GetDate() problems
I have a default date and a default time set in a table using GETDATE(). I have the fields formatted to display the date in the date field and the time in the time field. I have made parameter queries and reports based on them. The problem is that the queries do not read the date field...- ebic
- Thread
- Replies: 5
- Forum: Microsoft: Access Project (ADP)
