How do I make a widget shows how much a show has made between the Onsale Date and its first preview?
Nathaniels right.
However i agree that it'd be great to filter orders by something like...
Order_dt < MIN (Perf_dt)
Marketing ask me that all the time (not in so many words). I might play around with custom ranges and see what i get