Find a function that will identify the day of the week for a give.

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

Guest

I am trying to use the datepart function to ID the day of the week for a
given date. I am having a heck of a time learning access queries. especially
the expression builder. I just don't get it. I will learn somehow I hope.
 
I am trying to use the datepart function to ID the day of the week for a
given date. I am having a heck of a time learning access queries. especially
the expression builder. I just don't get it. I will learn somehow I hope.
Click to expand...

Take your pick:
= DatePart("w",[DateField])
or....
= WeekDay([DateField])

For a week that starts on Sunday, today is 5.

or....
If you wanted to actually display the day of the week name, then use
=Format([DateField],"dddd") which will display Thursday.

See VBA help for the additional arguments you can use with these
functions.
 
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

payroll weeks / varying first day and week of the year 2
Year and Week Totals 2
function for date of first and last day through weeknumber 1
datepart returns erroneous week number? 2
Return all dates for 'next month' irrespective of year or day 4
Extract data by week numbers for rolling 10 weeks 2
Finding the first DAY of the week of a given week. 3
Need Monday date for given week number 4

Back
Top