Search results for query: *

Thanks ajrimmer for the assistance. I was tied up on another project and I finally got a chance to try your solution and it worked like a charm. Thanks again.

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...

Thanks cmmrfrds for your reply. I had already removed the adp file from the users machine so I can't check to see if it works fine on another machine. Initially I thought it was a formatting issue until I looked at the table on the users machine which contained the errors at the table level. I...

I have never seen an ADP format dates like this. I would like to know if this could potentially spread to other users of the database or even corrupt the database itself. If I am posting this question in the wrong forum could someone please point me towards the correct forum or any other place...

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...

It seems to do the trick. When I added the code to the parameter query it altered it to a new field without an output so I played around to get it in the right place. Now that it's working properly I'll fix up the rest of them and call my job done. Thank you very much for your assistance

Thanks for your response. The table has 1 field each for Date and Time which are filled out by default using getdate() and then formated for "Short Date" and "Long Time". The date field shows dd-mmm-yyyy in the table but shows dd-mmm-yyyy HH:mm:ss in the stored procedure. The time field shows...

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...