access 2000 date function

This article on the Microsoft Knowledge Base may apply to your situation (though it is presently specific to Access 97). Perhaps the workstation used to create the database has an updated version of control, or Jet, etc.

ACC97: Error Message: Function Isn't Available in Expressions in Query Expression
http://support.microsoft.com/support/kb/articles/Q194/3/74.ASP?LN=EN-US&SD=gn&FR=0&qry=+error%20+Date%20+function&rnk=81&src=DHCS_MSPSS_gn_SRCH&SPR=ACC

A specific date = #7/21/95# will restrict records to that date only if entered in the Date/Time fild's criteria line in queryview.

A specific date = < (or >)#7/21/95# will deliver records greater than or less than that date only if entered in theDate/Time fild's criteria line in queryview.

Todays date = Now() will restrict records to that date omly if enter in the Date/Time fild's criteria line in queryview.

I have used these in all versions of Access usine every operating system you mentioned without problem?? Hope this helps.

Hi there are several "Date" functions in Access. Which one are you trying to use. Send me or post the code like =Date() or Datepart () or whatever is you are using and I'll try decern where the difficulty is. I have 10 yrs with access i should beable to help.

This question was closed by the author