Change Date format

[berry]

Hi all,
How to change a date format?
Example:
6/5/2007
I want to change to 5 June 2007.
I get the date from the calendar. I had change the dateformat in the properties already. But the result still is not what I want. What should I do?
Thanks..

[Killer42]

How to change a date format?
Example:
6/5/2007
I want to change to 5 June 2007.
I get the date from the calendar. I had change the dateformat in the properties already. But the result still is not what I want. What should I do?

What you have is a Date data type. You can use the Format() function to format it however you want.

(This applies to VB6 - not sure how it works in later versions.)

[cmrhema]

What you have is a Date data type. You can use the Format() function to format it however you want.

(This applies to VB6 - not sure how it works in later versions.)

Try out this

Try this code

Private Sub Command2_Click()
Dim D1 As Date
Dim D2 As String
'If you keep D2 as Date it will not convert to the required format
D1 = Now
D2 = Format(D1, "dd/mmm/yyyy")
MsgBox D2
End Sub

[Killer42]

It's true that MsgBox will expect a string. But if you prefer, you can do it in one step, like so...

MsgBox Format(D1, "dd/mmm/yyyy")
or
MsgBox Format(D1, "Short Date")

[cmrhema]

It's true that MsgBox will expect a string. But if you prefer, you can do it in one step, like so...

MsgBox Format(D1, "dd/mmm/yyyy")
or
MsgBox Format(D1, "Short Date")

What I meant was whenever one formats a date it will be/has to be returned in a string
http://msdn2.microsoft.com/En-US/lib...a0(VS.80).aspx

[Killer42]

What I meant was whenever one formats a date it will be/has to be returned in a string
http://msdn2.microsoft.com/En-US/lib...a0(VS.80).aspx

Yes, I was just making the point that you can work directly with the returned string - you don't have to assign it to a variable first, unless you want to.

[cmrhema]

Yes, I was just making the point that you can work directly with the returned string - you don't have to assign it to a variable first, unless you want to.

Oh! I understood what you meant

[rizwan6feb]

Check out this
http://www.qualitycodes.com/tutorial...id=9&pageid=52

[sierra7]

Check out this
http://www.qualitycodes.com/tutorial...id=9&pageid=52

Thanks for that reference, it summarizes a lot of matters relating to dates.

However, to be pedantic, the OP has requested the full month name with no slashes, so the format would be;-

 
Msgbox Format(Date,"dd mmmm yyyy") 'not case sensitive
 

with the usual qualification that this is for US/English regional and keyboard settings.

S7