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

markshnier__you · 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.

carolmcconnell · Answer

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

carolmcconnell · Answer

Oops, this does not work.&nbsp; The min and max is not what I'm looking for.&nbsp; &nbsp;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.&nbsp;&nbsp;

markshnier__you · Answer

Sorry, but you are confusing me. Please make a brand new report and follow my instructions and let me know if that works.&nbsp;&nbsp;

markshnier__you · Answer

ie where [Enter Beginning Date] is on or after <ask the user>

where [Enter Ending date is on or before <ask the user>

If that is not working for you, I will have to do some testing, but please try what I suggested first.

Forum Discussion

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

5 Replies

Related Content

Building a report from multiple tables

Using Grid Edit to Edit Multiple Records at Once

Report help

Multiple Tables Report

Edit Multiple Records at Once with Grid Edit