Displaying DOW in Accss Form

[Guest]

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

 

[Allen Browne]

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

 

[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

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")