convert date to Month and year

  • Thread starter Thread starter SG
  • Start date Start date
S

SG

Hi,

I have a field, type is date/time, value is 11/30/2004. I like to convert it
to November, 2004 or just November. How can I do this?

Thanks in advance,
Sarah
 
Format([SomeDateFieldName], "MMMM, YYYY")

I think. Try that and/or chec the help file.

Rick B
 
Hi Rick,

That works and just what I want. Thanks a lot.
Sarah
Rick B said:
Format([SomeDateFieldName], "MMMM, YYYY")

I think. Try that and/or chec the help file.

Rick B


SG said:
Hi,

I have a field, type is date/time, value is 11/30/2004. I like to convert it
to November, 2004 or just November. How can I do this?

Thanks in advance,
Sarah
Click to expand...
Click to expand...
 
Back
Top