Applying a rolling date to reports.

[S4E]

I am trying to apply a date function to my reports that will show a rolling 14-day overview (current date and the previous 13 days) whenever the reports are run/refreshed.

I have been trying to use the date functions, but I am having little success.

Anyone have a solution?

Thanks,

S4E

 

[dbomrrsm]

a database table holding the information where your reports can look up to to get the dates that apply.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[AndersonCJA]

{table.field} is <= Currentdate and
{table.field} is >= currentdate - 13

 

[skrandel]

What problem are you actually having?

What database are you using.

You're going to have to do this with pre-defined conditions in your universe.

Steve Krandel
Symantec