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!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

First Day of Week...

Status
Not open for further replies.

VBorDeliver

Programmer
Jul 3, 2002
7
0
0
GB
Hi!

This is probably a really basic question but here goes anyway...


I have a report where I am grouping on a date for each week. By default it shows the sunday of each week as the group title, this works fine but I want this to be the Monday!

Thanks in advance!
 
Create a formula that calculates for Monday and then group on that formula.

{date}-dayofweek({date})+2 Mike

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top