Weekday function in Access

P

pmp350

How do I get the weekday function to return a weekday "label" instead of the
number?

Thanx,

Paul
 
A

Allen Browne

Use the Format() function instead of Weekday(), e.g.:
Format([MyDateField], "dddd")
 

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

2016 Project, adding a workday to custom field 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Excel: counting times and dates during non-traditional hours 0
Counting Weekdays in the Future 1
WEEKDAY 7
Change to formula to make it go to next weekday (i.e., avoid weekend days)? 6
How to format cell to get first capital letter? 5
Assistance with vbYesNo 3

Top