0

I need a date range grouped by week and month

Jet Reports Historic Posts

June 07, 2010 15:20

None

Follow

hello, I am creating a report for a client, and the client want to be able to put in a date range, usually 3-6 month date range…
What the client would like to have is the report look like this.
January
Jan. 1 - Jan. 7
Jan. 8 - Jan. 15
Jan. 16 - Jan 23
Total for January

Feb
Feb. 1 - 7
Feb. 8 - 15
etc
Total For February.

So i need it to group by month, and then by week. I can get the report to group by week, but I can't figure out how to add in the month ? Any suggestions ?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts June 11, 2010 12:49

  C3 = NL("Rows";"Date";;"Period Type";"Month";"Period Start";"1/1/2010..12/31/2010")
  D3 = NF(C3;"Period No.")
  E3 = NF(C3;"Period Start")
  F3 = NF(C3;"Period End")
  
  
  C5 = NL("Rows";"Date";;"Period Type";"Week";"Period Start";"1/1/2010..12/31/2010")
  D5 = NF(C5;"Period No.")
  E5 = NF(C5;"Period Start")
  F5 = NF(C5;"Period End")