Group by Week or Month

[Trishuli]

Hi,

I need a formula which allows the date to be grouped monthly or weekly based on the parameter. I have tried everything and hardly found any information for date to be grouped weekly. I think there is a month(x) to change it to month..but no WEEK!!! why??

Thanks!

 

[IanWaterman]

YOu can use datepart() to return week number.

DatePart ("ww", currentdate) returns 34

You can replace current date with your datefield.

Ian

 

[lbass]

If you want to be able to format the resulting field to "Jan 2010" or "8/15/10", then you could use a formula like the following to group on:

if {?Interval} = "Monthly" then
{table.date}-day({table.date})+1 else
if {?Interval} = "Weekly" then
{table.date}-dayofweek({table.date}) + 1

-LB

 

[Trishuli]

Hi Guys,

Thank you very much!