YearWeek report parameter

[ClowneUser]

Hi,

i have a report that returns all invoices, this works fine, but now i have been asked to add a parameter so the user can sort by week number and year or year/weeknumber, the field in the table that i need to query on is formatted dd/mm/yyyy.

Can anyone suggest a way to be able to do this please?

Thanks in advance.
Mick.

 

[lbass]

Do you really mean "sort" or do you mean select? You could use a record selection formula like this:

year({table.date}) = {?Year} and //number parameter
datepart("ww",{table.date}) = {?WkNo} //number parameter

-LB

 

[ClowneUser]

Yes sorry I did mean select and not sort, that formula works great.

Thanks very much for your help.

Mick.