I am trying to show a date an item was last used from our inventory, the last time before it was ordered.

 

I can generate the date for this so long as no subsequent usage has occured since the order date simply by stating IF {usage date}<{Order date} Then {usage date}

 

but this gives blanks where there has been subsequent usage.  In fact I want to see the previous issue, closest to the order date, so I add (to the above) "Else" but then get stuck as effectively I then ask it to do the same again.

 

The data looks something like this:

 

Item  Ordered    Last Used   

a          10-Aug      11-Aug

b          10-Aug      14-Aug

 

I would be looking to get the lines in bold text returned.  Tried everything I can think of and have been able to search on t'web, but running out of ideas.

 

Shame to lose it on the last little obstacle though.  Many thanks in anticipation of some help?

 

 

 

 

 

 

Ah, thanks, but I don't necessarily want the last used record.  It is the last used record before the order was placed.  It is highly likely (well about 80% of my results) that further usage will occur before the order is replenished, so I need to monitor the time between the usage occurring and the order being placed, to order receipt, whilst taking out any subsequent usage.

 

thanks