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

Hi
try
format(variable,"MMMM YYYY")

--
Regards
Frank Kabel
Frankfurt, Germany


Sworkhard wrote:
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

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