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

Dim dte As Date
Dim s As String

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

returns:
January 2004

HTH
Dana DeLouis

"Sworkhard" wrote in message
...
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