days of week

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

i have a database of days that cleaners clean certain
places. I wanted to do a query to find only days to clean
after tuesday. so this would mean not monday but it doesnt
work. does someone know how to do this?
 
try the follow code,
1-Sunday
2-Monday
3-Tuesday
you may try to play with the number with weekday to see
that it really means

SELECT Table1.name, Table1.date, Weekday([date],2) AS date1
FROM Table1
WHERE (((Weekday([date],2))<>2));

May
MCP in Access and SQL Server
 
Back
Top