Display Day of Week Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I show just the day of the week in a date field, i.e., "Tuesday".
TIA!
 
Today's date:

format(date(),"dddd")

Table/query field:

format(MyDateField,"dddd")

You could also change the format in the properties
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting days of the week 2
Automatic 1 Week Query/Report? 19
How to display only the days of the week? 5
Spam 4
Monday through Friday Report 1
How can I show dates as days of the week in Access? 1
showing days of the week from the date 6
Formula to tell day of week 2

Back
Top