Grouping by weekly date.

[tomcram]

I have written a report using a Visual Foxpro data source.
I have 1 little problem. I am grouping the data by transaction date with totals for the week. I selected to group by and then weekly. I want the date shown for each week to be the date on Sunday every week. At present it is picking up the first transaction date in a particular week and printing that as the date. I need a formula that will do this for me but it's really got me puzzled. Anybody got any ideas?

 

[dgillz]

Write a formula that finds the next sunday. The If statement checks to see if the date is already a sunday, and if it is not, thr formula will add the appropriate number of days to find the next sunday.

If Dayofweek({date}) =1 then {date} else
Dateadd("d",(8-DayofWeek({date})),{date})

Then group on this formula. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com