Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get the day of week in SQL in MS Access

Status
Not open for further replies.
paulobrads

paulobrads

Programmer
Jul 13, 2006
28
GB
I'm writing queries in MS access and need a way of determining the day of the week from a date value - any ideas?

Cheers.
 
Sort by date Sort by votes
WEEKDAY(datecol)

are you using microsoft access by itself or access as the front end for a microsoft sql server database? is this for a passthrough query?

r937.com | rudy.ca
 
Upvote 0 Downvote
Cheers,

I actually found

DatePart("w",Date()))=2

as a check to see if today's day is a Monday.

Many thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
423
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
544
SaltyTheFrog
SaltyTheFrog
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
892
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
767
SashaBuilder3
SashaBuilder3
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
824
pjw001
pjw001

Part and Inventory Search

Sponsor

Back
Top