Filter Report By Week of Selected Date 1

[Mav3000]

Hi, I'm using CR10. I have a report that works fine and shows information based on a given month. The Report uses a date parameter to ask the user to select a date.

The report then only shows data where the month and year of a date field is equal to the month and year of the data parameter.

However, the user now wants to see data specific to a certain week, and no longer a certain month.

How can I do this in CR10? I can't find any formula functions that return the week number.

I need to filter the report to show all records where the week number is equal to the week number of the parameter.

Any ideas? I'm really stumped on this one!

Richard

 

[IanWaterman]

datepart("ww",{table.date})

Ian

 

[Mav3000]

Wow thanks very much Ian for the quick reply. I can't believe how simple the solution is, but kind of guessed I was missing something simple.

I'll tie this in with a year comparisson to to ensure that the week number relates to the week number of the same year too.

Thanks again,

Richard

 

[Mav3000]

Hi,

Just a quick follow up to this question - is it possible to return the week commencing date of the entered parameter date?

I've searched Google for the answer but can't find anything on this.

Thanks, Richard

 

[Mav3000]

I seem to have got this working by using this formula:

{?Report Week}-(datepart("w",{?Report Week})-2)

I want it to return the Monday as the week commencing date, which is does.