When I was comparing order status, first, last and anything in between I found a correlated subquery at the universe side worked well for me.
A few ideas discussed below.
I’m pretty sure you could do something with variables, but you will need the date.
You will need to use Min somewhere along the line 
https://bobj-board.org/t/140234 [/url]
Mak 1 
(BOB member since 2005-01-06)