Create a formula to show items outwith the selection 1

[fkelly72]

I have an inventory database that lists my products.
My database contains a field called "Last Date sold"
I wish to generate a report which will prompt me for a date range and show me all items that have NOT been sold up to and during that date range.

Example
Item# Description last Sold Date
1 T-Shirt 27/09/2011
2 Shirt 31/08/2011
3 Hat 01/01/2010

Let's say I enter a date range of 01/09/2011 to 28/09/2011
The report should show me item's 2 and 3 as they do not fall within this range.

Any help would be appreciated.

 

[lbass]

If you really mean products that were not sold UP TO an during the date range, you would need to evaluate when products were first sold, not last sold.

If you mean you want to identify products whose last sold date is prior to the date range period, then you can use a selection formula like this:

{table.lastsolddate} < minimum({?DateRange})

-LB

 

[fkelly72]

Thank you LB for your help. Worked perfectly