Qrew LegendNot tested, and this may warp your brain a bit, but I think we can get this working with this approach.
Create a new formula date field called [Enter Beginning Date] where the formula is
Min([Date Received],[Date Submitted])
Create a new formula field called [Enter Ending Date] where the formula is
Max([Date Received],[Date Submitted])
This make an <ask the user> report asking for those two field values.
While, this may be confusing to us, the intention is to make it stupid simple for the user.
Thanks. I would not have figured out the formula on my own.
Oops, this does not work. The min and max is not what I'm looking for. This is what I'm trying to replace. This prompts the user to put in the date range twice. Just as an FYI a record will not have both of these fields completed, it will be one or the other.
Qrew LegendSorry, but you are confusing me. Please make a brand new report and follow my instructions and let me know if that works.
