Use Last7Days function

[lana123]

Hi, people.
I have to create the report that includes only the items created during the last 7 days. I need to create the parameter "Open Date" based on the Last7Days function.
I read about this function but I cannot understand how connect this function with the OpenDate field and select the items open during 7 days.
I'll appreciate any help.
Thanks in advance.

Lana

 

[synapsevampire]

A parameter wouldn't be based on a date function, you would use a parameter in lieu of the function.

To limit data to the last 7 days, use:

Report->Edit Selection Formula->Record and enter something like:

{table.field} = last7days

To use a parameter instead, try:

Insert->Field Object->Right click parameters andselect New, name it, choose a type as date and select range

Now modify the record selection as follows:

Report->Edit Selection Formula->Record and enter something like:

{table.field} = {?MyDateParameter}

-k