Converting a Date to a string

[Guest]

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

 

[Frank Kabel]

Hi
try
format(variable,"MMMM YYYY")

 

[jaf]

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


| 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