Date Formatting

[loksdhar]

How do I shorten a date to just pull the month out

For example I have a date of 19-Mar-2009 & I just want to displat "March"

I dont know

Loksdhar

 

[Al Campagna]

loksdhar,
Format the field as...
mmmm
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[ryguy7272]

In a query?
Mo: Month([YourField])
1, 2, 3, 4, 5, etc.

Mo1: Format([RT_Start_Date],"mmm")
Jan, Feb, etc.

Mo2: Format([RT_Start_Date],"mmmm")
January, February, etc.

HTH,
Ryan---