469,271 Members | 1,009 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Format date

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
Jul 19 '05 #1
1 2705
http://www.aspfaq.com/2313

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Richard Liddiment" <Ri*****@cfp-software.co.uk> wrote in message
news:bq**********@hercules.btinternet.com...
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Simon Brooke | last post: by
5 posts views Thread by Macca | last post: by
13 posts views Thread by Roy | last post: by
20 posts views Thread by andreas | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.