How to user format function to get full month name 1

[SkyHigh]

Hi
subject says it all, I want to get full month name i.e. January instead of just Jan with fist letter being in upper case, out of a given date

Can someone please help me.
Thanks much
Brenda

 

[RoyVidar]

[tt]strconv(format(date,"mmmm"),vbpropercase)[/tt]

Did you try the help files?

Roy-Vidar

 

[PHV]

Something like this ?
StrConv(Format(Date(), "mmmm"), vbProperCase)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkyHigh]

Thanks both of you !!!