I am designing a report in which I want to bring back the effective insurance during a specific time period.

 

The table contains effective_dttm and expiration_dttm

 

If the insurance is currently effective, the expiration_dttm field is NULL.

 

I have a date range parameter set up to pull back those results by DOS (or process date).

 

How would you reccommend I set up a formula to pull back those results that if the date range is 1/1/2007 to 3/31/2007 and have an expiration date that falls within that date range AND those that have an effective date in that date range, but an expiration value of NULL?

 

Thank you.

I have set up my formula to be:
{Payer.Effective_Date} <= {?Date Range} OR {Payer.Expiration_Date} in {?Date Range}

 

this is bring back date ranges that are outside the 1/1/2007 to 3/31/2007 date range that I entered. Any advice?

 

I would only like those values to pull through that have an effective date that is lower than the Date Range parameter and a NULL expiration date.