Hi,
I inherited a report with several date range prompts (I usually go for start/end dates).
All prompts are optional. The requirement is that when a range is chosen, then the date can't be OracleNoDate (2999-dec-31), even if latest date is chosen.
Is there a simple solution other than converting to start/end date and putting in some calculations?
I don't think I can do a max(prompt) in the filter.
Thanks