DATE function gives me a headache

[sabavno]

Hi

I use this line in my code...
CStr(Format(Date, "ddmmyyyy&quot)

When I run the code on my machine, everything works fine, but when I run it on another machine, it doesn't recognize the function DATE.

Why?

The other machine has the same version of Access.

When I try to change DATE to NOW, then FORMAT does not work

What the heck is going on with my code?

I will appreciate any suggestions.

Thanks

 

[tunsarod]

I remember something similar occuring in an App I built where my development machine had a reference set to DAO 3.5 object library but the machine I transferred the App to had a reference to an earlier DAO library.

Rod