How to Spell Months by VBA Code and SQL?
'(c) 2005 João Tito Lívio
'This code can only be use as a part of an Application and could not be sell
'To REQUEST a full functional sample please > Click
VBA
MsgBox (Format(Now(), "mmmm"))
MsgBox ("Month: " & Format(Now(), "mmmm"))
MsgBox ("Month: " & Format(#1/1/2005#, "mmmm"))
SQL
SELECT Table1.Data, "This is month: " & Format([Data];"mmmm") AS strConvertion
FROM Table1;