week commencing

ybalaram

when a user enters date range (from & to dates), the report should populate the values on weekly bases by grouping the start day as monday.

Any help is highly appreciated .
Thanks in Advance.

mwilliams

Hi ybalaram,

So, you want to group the report by week, only with the week starting on monday rather than sunday? Is this the issue? If so, creating your own computed column that uses the getWeek() function, but subtracts one from the value if the day is sunday. This would move the sundays back a week and cause your grouping on this column to be correct, Mon thru Sun. Let me know.