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 derfloh 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
Joined
Jul 13, 2006
Messages
28
Location
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 Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
895
Chris Miller
Chris Miller
MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
908
Chriss Miller
C
Andrzejek
  • Locked
  • Question Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
895
SaltyTheFrog
SaltyTheFrog
peac3
  • Locked
  • Question Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3

Part and Inventory Search

Sponsor

Back
Top