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

Question

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 would be user prompts.

Date received is on or after Beginning Date and

Date received is on or before Ending Date

or

Date Submitted is on or after Beginning Date and

Date Submitted is on or before Ending Date.

How can I create the custom prompt for Beginning Date and Ending Date, so the user is not prompted to put in dates for both fields.

Thanks

MarkShnierYou · Answer

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.

Sign up