Record Select - Nulls not showing 1

[AdamRicko]

Hi folks,

I am having trouble getting my selection formulae to show both nulls and delivery dates over 90 days for a specific product.

I am using CR2008.

My formulae currently looks like:

{LastSold.CustomerNo} startswith "T" and
(UPPERCASE(LEFT({LastSold.CustomerName}, 6)) <> 'CLOSED')
and ({LastSold.DeliveryDate} in Over90Days
or isnull({LastSold.DeliveryDate}))
and {LastSold.ItemNo} = {?Item}

This formulae only shows me customers who have not bought a product for 90 days, but does not show me nulls.

I have tried this without:

({LastSold.DeliveryDate} in Over90Days

e.g.

{LastSold.CustomerNo} startswith "T" and
(UPPERCASE(LEFT({LastSold.CustomerName}, 6)) <> 'CLOSED')
and isnull({LastSold.DeliveryDate})
and {LastSold.ItemNo} = {?Item}

This works with showing nulls for a delivery date.

I am pretty new to CR so any help would be greatly appreciated.

Thanks in Advance,

AdamRicko

 

[kskid]

Reverse the dates and specify the isnull first.

{LastSold.CustomerNo} startswith "T" and
(UPPERCASE(LEFT({LastSold.CustomerName}, 6)) <> 'CLOSED')
and
(
isnull({LastSold.DeliveryDate}) or
{LastSold.DeliveryDate} in Over90Days
)
and {LastSold.ItemNo} = {?Item}

 

[AdamRicko]

Thanks alot kskid, it worked a treat.