Converting a Date to a string

S

Sworkhard

I have a date in 01/01/2004 form and want to convert that value to January 2004 form as a string. Is there a function in VBA that will let me do this?

Thanks
 
D

Dana DeLouis

Dim dte As Date
Dim s As String

dte = "1/1/2004"
s = Format(dte, "mmmm yyyy")

returns:
January 2004

HTH
Dana DeLouis

Sworkhard said:
I have a date in 01/01/2004 form and want to convert that value to January
Click to expand...
2004 form as a string. Is there a function in VBA that will let me do this?
 
Top