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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

any way to change the default for the start of a week?

Status
Not open for further replies.

jymm

Programmer
Apr 11, 2002
707
US
I have just a few Crystal 9 (sorry) reports left. One of them the user has the report grouping on the date then in the group options saying print 'for each week' (so they get one line for each week). This was great till the regulators decided that their week starts on Monday instead of Sunday (only took them about 7 years).

so I can make a new field that is the Monday date and group off of that (instead of having Crystal doing the work), but I was curious if there was any way to define the week begin date within Crystal instead...
 
I believe your only option is to use a formula. One formula is:

{table.date}-dayofweek({table.date})+2

-LB
 
that is the direction I was going - I know, as they say in Spain - El-too-bad-oh ... ok - maybe my spanish is not very good. ;)

thanks for the validation LB!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top