Saturdays and Sundays

B

Barry

Gina Whipp, Thanks for the help, but I couldn't get that to work for me.
Maybe I didn't explain well enough... I'm doing a payroll program. In the
report, I want the dates for Sunday xx/xx/06 to Saturday xx/xx/06 to show in
the header. Payroll reflects all work done between a given Sunday and
Saturday in a week. The format(now(),"ww")-1, will produce last weeks pay
week, but I also want it to show: "From Sunday xx of June, 2006 to Saturday
xx of June, 2006." How do I get the report to show these dates?

In advance: Thanks for the help!
 
D

Duane Hookom

You can calculate the Sunday of a date with the expression
DateAdd("d",-Weekday([DateField])+1,[DateField])
Add 6 to the above expression to get the Saturday date.
 
G

Gina Whipp

Barry,

I see Duane gave you the answer... did it work?

Just a note, I was watching the initial question and missed this one. When
posting a reply try to reply to the initial question most people don't read
EVERY question, at least I don't, I wouldn't get any work done.

Gina Whipp
 
Top