Parameter = Hire Date plus 90 days

[bluraz]

Crystal XI and SQL

I need my report to only look at the data for all active employees between their "original hire date" and "original hire date plus 90 days". The user should not be prompted for any parameters. I have made several unsuccessful attempts.... Any suggestions?

I prefer to create my reports using command statements, but do use the Record Selection while testing.

 

[lbass]

Do you mean you are looking for people who are currently within that range? Use a record selection formula like this:

{table.originalhiredate} in currentdate-90 to currentdate

-LB