Skip to Content
Former Member
Jul 16, 2013 at 02:26 PM

Best way to display data based on two weeks of data



I have a report that has a 2-week parameter date range. Say start 6/16/13 to 6/29/13

I need to have a formula for Week 1 (6/16/13 - 6/22/13) and Week 2 (6/23/13 - 6/29/13)

What's the best practice to accomplish this task? Using DateAdd for a formula? Or some other date function? I'm probably going to put the results in a group footer or in the details section.

Thanks in advance.