Format Function, Isn't Formatting.

[radarmy]

I have:

strFileName = MyPath & Chr(92) & "activity_" & Format(System.DateTime.Now, "MM-DD-YYYY") & ".csv"

And for some reason the format part is returning:
07-DD-YYYY

And not, 07-25-2003.

I can't seem to figure out what is wrong. Any ideas?