Current Week Day in Access Table

  • Thread starter Thread starter John Keane
  • Start date Start date
J

John Keane

Hi

I have a table which displays current DATE.
Can anyone tell me i can append the corresponding DAY of
week to it or in a another field.

Example: Tuesday, 14 September 2004.

Any Help appreciated.

Thanks
John.
 
Set the Format property of the text box to:
Long Date
or:
dddd dd mmmm yyyy

In the context of a form, you may prefer to have the day name in another box
beside the original one. Set these properties for the 2nd text box:
Control Source =[YourDateFieldNameHere]
Format dddd
 
Back
Top