Long Date

E

Emma

Hi I was wondering if there's a way to make a long date but without the day
of the week ie June 18, 2009?
 
F

fredg

Hi I was wondering if there's a way to make a long date but without the day
of the week ie June 18, 2009?
Click to expand...

Do you mean you wish to display the 6/18/2009 date as
June 2009?

Simply write
mmmm yyyy
on the control's Format property line.

If you mean to actually store the date without the day in a Date
datatype field, then no, you cannot. A date must have a month day and
year component.
 
J

John Spencer (MVP)

You need to use a custom format for that.

Replace Long Date with "mmmm d, yyyy" (include the quote marks)

"mmmm d, yyyy"

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
E

Emma

In the design view of the form, in the property sheet of the format I put
"mmm d, yyyy" But that's all that shows up no month or anything. Maybe I'm
not explaining it well, what I would like is the day ie "Sunday" not to show
up.
 
J

John W. Vinson

In the design view of the form, in the property sheet of the format I put
"mmm d, yyyy" But that's all that shows up no month or anything. Maybe I'm
not explaining it well, what I would like is the day ie "Sunday" not to show
up.
Click to expand...

What do you mean by "the property sheet of the format"?

What John was suggesting is to open the Form in design view. Select the
textbox in which you are displaying this date field. Type

"mmmm d, yyyy"

just like that, quotes and all, into the Format property.
 
Top