Problem with date and returned records 2

[byteofram]

Ok, I have a report that needs to pull the terminated employees for the last week from the SQL database. I can pull ALL the terminated employees, but I only need it to show from todays date and the previous 7 days (this report is scheduled to run every Fri) data. Without using parameters, how do I accomplish this? I'm a rookie report writer, but this report will really help out my department.

 

[vidru]

In your record selection formula, one of these will work:

1) This will give you the last 7 days:
[tt]{Table.TerminationDate} in Last7Days[/tt]

2) This will give you the last 8 days:
[tt]{{Table.TerminationDate} in CurrentDate - 7 to CurrentDate[/tt]

-dave

 

[byteofram]

Thanks for your help! That's exactly what I needed and works perfectly. Heres a star!