Hi Susan,

I suspect the ANDs and ORs are not overlapping with the required logic.

I believe this one works, using slightly different logic to remove OR out of the process:
Code:
Sale Start Date - Not Equal To        - blank            AND NOT
Sale Start Date - Floating Date Range - After Today      AND NOT
Sale End Date   - Floating Date Range - Before Today

This ensures that there is a sale date range entered and is before or equal to today, and that the end date is after or equal to today.
_________________________
Regards,
Softrak Tech Support