Create a parameter to include a contract start date and a sold date <

[pmella2000]

Hello,

I need to create a parameter that includes:

- Contract Start Date in the current month

OR

- Any contract that was sold during the current month whose start date is less than the current month (backdated)

Is this possible? At the current time, there are two exact reports exceot they have different parameters. One has sold start and end dates and the other has contract start date ranges. I have to combine the two.

Many Thanks,
Pamela

 

[lbass]

I think you could do something like:

(
{?parm} = "StartedThisMonth" and
date(year({table.contractdate}),month({table.contractdate}),01) = date(year(currentdate),month(currentdate),01)
) or
(
{?parm} = "SoldThisMonth" and
date(year({table.solddate}),month({table.solddate}),01) = date(year(currentdate),month(currentdate),01)
and
date(year({table.contractdate}),month({table.contractdate}),01) < date(year(currentdate),month(currentdate), 01)
)

-LB