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]

Re: Format date

http://www.aspfaq.com/2313

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"Richard Liddiment" <Richard@cfp-software.co.uk> wrote in message
news:bqfu8u$a6e $1@hercules.bti nternet.com...[color=blue]
> 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
>
>[/color]