Hi Susan,
What version of Adagio Inventory do you have installed?
With the service pack 2015.02.24 installed - and perhaps earlier versions as well - you can create a filter with "Sale End Date" - "Floating date range" - "After today". The inclusion of After today (and Before today) as floating date range choices is fairly recent across Adagio programs. These choices are at the end of the floating date range list.
You probably will also want to include in your filter a second criteria to check that "Sale Start Date" - "Floating date range" - "Before today" to ensure that Today is within the sale date range, rather than being prior to the entire range.
_________________________
Regards,
Softrak Tech Support