Displaying DOW in Accss Form

A

aMack

Is there a simple way of displaying a date field as the Day of the Week ie:
Monday, Friday, etc... in an Access Form?

Thanks
 
A

Allen Browne

If you have a date field, you can set the Format property of the text box
to:
dddd
 
F

fredg

Is there a simple way of displaying a date field as the Day of the Week ie:
Monday, Friday, etc... in an Access Form?

Thanks
Click to expand...

To display a date as the day of the week (Monday):
=Format([DateField],"dddd")

To display a date as the day of the week abbreviated as Mon:
=Format([DateField],"ddd")
 
Top