Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Officer
10 months ago

Report to prompt for one date but be used for multiple date fields

I need to prompt the user for a beginning date and ending date range but I need those dates to be for more than one field. So the report would be something like this.  The Beginning and Ending Date ...
reports
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
10 months ago

Not 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.

 

CarolMcconnell's avatar
CarolMcconnell
Qrew Officer
10 months ago

Thanks.  I would not have figured out the formula on my own.