A real EASY one! I think?? *10172008

  • Thread starter Thread starter J.Alladien
  • Start date Start date
J

J.Alladien

Hello everybody,

I would like to format a date fe 10/17/2008 as "Friday" <how do I do that ?

Thanks in advance!
 
J.Alladien,

Depends where you want this to happen.

If this refers to a textbox on a form or report, which is bound to a
date field, set the Format property of the textbox to:
dddd

If you want to return this within a query for example, then enter the
equivalent of this in the Field row of a blank column in the query
design grid:
ShowAsDay: Format([YourDateField],"dddd")
 
Format([SomeDateField],"dddd")

Or if you are using the format property of a control, then enter dddd to
show just the day name.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top