data format- get month in letters ?

[ooops]

Hi,

the date keyed in is mm/dd/yyyy. How do I get the month in letters ? Thanks.

 

[Blorf]

Try = Format([date],"mmmm&quot

ChaZ



Ascii dumb question, get a dumb Ansi

 

[CajunCenturion]

You might try the following:

MsgBox Format(Now(), "mmmm dd, yyyy&quot

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[MichaelRed]

see the ubiquitous {F1} (a.k.a. Help) for a reasonable tutorial on Format


p.s. it works for many other functions as well.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[serino]

HI,

I have a similiar situation. I have the folowing code:

=Format$([ARRIVAL_DATE],"mmm&quot

What I would like to do is extract all arrival for the current MON and year.

Any help appreciated

Chuck