Format() turns my dates on their heads

[biot023]

Hallo again.
I have a problem with the Format() function, in that it keeps switching the order of my dates from dd/mm/yy to yy/mm/dd or other variations, no matter that I might type in something like:
Format(a_date,"dd/mm/yy&quot
Does anybody know how to format so the date appears dd/mm/yy?
I think the yy/mm/dd is an American custom, so probably default to Access, but I really need dates formatting English-style.

Cheers,
Douglas JL If it don't make you laugh, it ain't true.

 

[maggieb]

Have you checked your regional settings in Windows?

 

[biot023]

Yeah - they're all straight.
I think I'm looking for some special attribute or flag in Format().
Cheers, though.
DJL If it don't make you laugh, it ain't true.