plz help !! Undefined function 'Date' in expression

[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

 

[Allen Browne]

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

 

[MrCC via AccessMonster.com]

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