Query with Date Format In Access Runtime

[snyperx3]

I have a database that I must distribute to several computers that only have Access 2002 Runtime installed. In several of my queries i have to display the date in the format mm/dd, or an example: "12/07". I was using

Format([Date],""mm/dd"")

but apparently that is an issue. When I try to run the report that uses this query I get the message that Format([Date],""mm/dd"") is not allowed. The only thing is, I also have this installed on a PC at my office that only has Access 2002 Runtime on it, and it works fine. Should I change this query expression, or is this something to do with a missing .dll or something?

Thanks for any help you can provide.


-Pete

 

[snyperx3]

P.S. Its in double quotes because im executing the query in a VBA statement where the expression is somewhat like:

qdf.SQL = "Select Format([Date],""mm/dd"") As Date2........and so on"

-Pete