Date Format

[marconi86]

I need to change the format of a date field from mm/dd/yyyy to the day
of the week (Sat, Fri, etc.) Any help?

 

[Rick Brandt]

I need to change the format of a date field from mm/dd/yyyy to the day
of the week (Sat, Fri, etc.) Any help?

Set the format property to "ddd". This only affects how it is displayed.
Dates are always stored exactly the same.

 

[Guest]

On your form go to the control that displays your date, select the control
and go to format. under format type "dddd". this should take care of yuouur
problem.

 

[Guest]

Hi.

Try: Format(DateField,"ddd")

For full day names, add a fourth d.

-Michael

 

[Guest]

Hi,
leave the values as they are in the table...if you want to display only the
date part then format the value at runtime on forms/reports as you wish.
You can either use the Format() Function e.g.:

=Format([YourDateField],"ddd")

Or you can use the WeekDay function as well.
HTH
Good luck