M
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?
of the week (Sat, Fri, etc.) Any help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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.
G
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.
and go to format. under format type "dddd". this should take care of yuouur
problem.
G
Guest
Hi.
Try: Format(DateField,"ddd")
For full day names, add a fourth d.
-Michael
Try: Format(DateField,"ddd")
For full day names, add a fourth d.
-Michael
G
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
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