By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Date format

P: 1
hi.

i'm using a vb calendar to insert a date in a user form, but i can't set the date format to dd/mm/yy .

for example:

if i use:


Text1.Text = Format(Text1.Text, "dd/mm/yyyy")

to set the date format, if the date i choose is, for exemple, 15-out-2008, the output is correct, but if the day is below 12, for exemple, 9-out-2008, the output is out-09-2008.


can anyone help please?
Oct 2 '08 #1
Share this Question
Share on Google+
2 Replies


FishVal
Expert 2.5K+
P: 2,653
Try to use Textbox.Format property.

Regards,
Fish
Oct 2 '08 #2

100+
P: 167
hi.

i'm using a vb calendar to insert a date in a user form, but i can't set the date format to dd/mm/yy .

for example:

if i use:


Text1.Text = Format(Text1.Text, "dd/mm/yyyy")

to set the date format, if the date i choose is, for exemple, 15-out-2008, the output is correct, but if the day is below 12, for exemple, 9-out-2008, the output is out-09-2008.


can anyone help please?
A membere here had the same problem recently.
He solved it by setting Local Date and time on his PC.
Here is that post
Oct 3 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.