Format date

[Richard Liddiment]

I am using FormatDateTime( mydbDate, vbShortDate) but it is NOT returning
the date formatted according to my regional settings. My regional settings
are "dd/MM/yyyy" but my date is returned as "d/m/yyyy".

Where is it getting the format from so that I can correct it or is there a
better way to format the date, the way I want it?

I have tried the VB format function but get
Type mismatch: 'Format'

Richard

 

[Aaron Bertrand - MVP]

http://www.aspfaq.com/2313