Date() function problem in Access 2000.

I use Access 2000 my Date() function returns always the error "#name".
Is there any solution?

Make sure that your field name is NOT called Date.

try =Date()
If this is in a field in a table, format the field for the date format you prefer

i am trying to use the date function in a form to get the current date,but still having error"#name?"