Weekend Date

  • Thread starter Thread starter caloy
  • Start date Start date
C

caloy

If I have a set of Dates in format mm/dd/yy, what function or expression do I
use to find the weekend date? Sunday - Saturday

Ex. 6/1/08, 6/2/08, 6/3/08,...6/7/08 (not knowing that 6/7/08 is a Saturday)
 
assuming you have table with a field eventdate

create query showing [eventdate] and create an expression [exp1:
weekday(
![eventdate])

this expression will return 1=sunday, 2=monday, etc.

in the criteria field for the expression (where in sql) you could say <>1
and <>7 (excludes sun and sat).

hope that helps.
 
Back
Top