Week Day Totals for a Month

[SuperX]

Hi All

I have a crystal report that returns a daily total of numbers and this is done for a period of a month. What I then need to go is catergories them by week day (total for all the Mondays, Tuesdays and so on..).. So for a month of the totals for each day of the week... So in the example attached I will need to total the 31/10 and 7/11 which will be the totals for Wednesdays. Attached is an example of what my current crystal report looks like.. What function can I use in crystal to group it by week days?

Thanks in advance...

Thanks
Stu

[Lugh]

Check out the DayOfWeek function. It returns the number of the day of the week (e.g., Sunday is 1, Monday is 2, etc.). If you look at the bottom of the help page, though, it also gives the syntax for returning the day name:

["Sun", "Mon", "Tues",...] [DayOfWeek(Date)]