DATE format (easy one)

[CoMMiE]

Hi all

How do you change the format of the DTPICKER(datepicker) from diplaying :

month/date/year to date/month/year

Any help will be greatly apreciated

[reeset]

Just use the Format command like this:

Private Sub Command1_Click()
ddate = Format(Date, "dd/mm/yyyy")
MsgBox ddate

End Sub

[honeybee]

Rightclick on the DTPicker control. In the property pages, set the date format property to 'custom format' and just below that in the custom format text box enter your own date format like:
'dd mm yyyy' will give you '01 08 2000'
'dd mmm yyyy' will give you '01 Aug 2000'
'dd/mm/yyyy' will give you '01/08/2000'

By the way, you don't look American. Where are you from?

[CoMMiE]

Thanks for the help guys

By the way honeybee how do you know i am not an AMERICAN

[honeybee]

Set Date British

That's what all non-US people are doing in their programs!
Well, am I right or am I wrong?

[HeSaidJoe]

I like YYYYMMDD
I must be an alien of some kind!