plz help !! Undefined function 'Date' in expression

  • Thread starter Thread starter MrCC via AccessMonster.com
  • Start date Start date
M

MrCC via AccessMonster.com

hi all

please help i got mad !!!!!!

i was using date() function to get the current in access query & vba and both
doesn't work and i got this msg


Undefined function 'Date' in expression

i tried all the tricks in the internet about fix the ref. and no way .still
as it is

any new tips plz

or another way to get the current date

thanks
all
bye
 
The most likely problem is that your database has a problem with library
references. To fix it, see:
Solving Problems with Library References
at:
http://allenbrowne.com/ser-38.html

If that is not the case, you may have a naming clash (something else named
Date.)
 
i got a nice solution

get date using windows api and kick out the access :))))

Function GetDate() As String
Dim myTime As SYSTEMTIME
Dim strBuffer As String
Dim lng As Long

GetLocalTime myTime
GetDate = CStr(DateSerial(myTime.wYear, myTime.wMonth, myTime.wDay))

End Function

i hope all try it
 
Back
Top