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.
 
Back
Top