Weekend Date

[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)

 

[raskew via AccessMonster.com]

This will return Saturday's date.

x = #6/12/08#
? x - weekday(x)+7
6/14/2008


HTH - Bob

 

[jschmuck9]

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.