Parameter Question 1

[kimchavis]

I know this is probably really easy but for some reason it isnt working:

Im trying to look at two different dates for populating in a parameter. At first I tried an or statement:

{LOAN.HELD_FOR_INVESTMENT_DATE} = {?Enter Invester Purchase Date Range}
or
{LOAN.INVESTOR_PURCHASE_DATE} = {?Enter Invester Purchase Date Range}

But this fails because if the {LOAN.HELD_FOR_INVESTMENT_DATE} is null then it doesnt look any further,

Then I tried:

if{LOAN.HELD_FOR_INVESTMENT_DATE} in {?Enter Invester Purchase Date Range} then {LOAN.HELD_FOR_INVESTMENT_DATE} = {?Enter Invester Purchase Date Range}
else {LOAN.INVESTOR_PURCHASE_DATE} = {?Enter Invester Purchase Date Range}

That didnt work either.

I want the loan to pull if the date range parameter exists in either date field.

Any help would be appreciated.

Thanks,
KIM

 

[kskid]

If you are using it in Select Expert, then

(not isnull({LOAN.HELD_FOR_INVESTMENT_DATE}) and
{LOAN.HELD_FOR_INVESTMENT_DATE} in {?Enter Invester Purchase Date Range})
or
(not isnull({LOAN.INVESTOR_PURCHASE_DATE}) and
{LOAN.INVESTOR_PURCHASE_DATE} in {?Enter Invester Purchase Date Range})