Hi,
sub test()
mystring="01/01/2004"
mydate=format(mystring,"mmmm dd yyyy"
debug.print mydate
end sub


--
John
johnf 202 at hotmail dot com


"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