Find records between two date fields

Hey Andrew,

Thanks for posting!

To accomplish what you described, you would need to create a Table report with specific Filters. The Filters you need would be:

Assigned Date is after <ask the user>

(and)

Project Finish is before <ask the user>

This will generate a report where the user picks the dates for each date field. See the attachments.

More on ask the user reports here:

http://www.quickbase.com/user-assistance/#selection_criteria_prompt.html


I hope this helps!

Brendan

Hi Brendan,

Actually that won't accomplish what I need. Using your method take the following example:

Assigned Date: The user chooses 3/1/14

Projected Finish: User chooses 3/10/14

This will show any records with the assigned date on or after 3/1 AND the projected finish on or before 3/10/14, but it wouldn't show records where the projected finish falls in between 3/1 and 3/10 if the assigned date in that record is before 3/1.

Essentially, I need to take a date and evaluate each record's assigned date and projected finish against that date before or after. I understand that this in essence kind of a "reverse" way of the built in reporting and am starting to think that this is not an option in Quickbase. Judging from the lack of responses, it looks like yet another feature request and back to the drawing board...

I have the same situation. I need to report on contractors that were active as of a particular date. I want the user to enter a date and I can select all contractors whose start and end dates are between the user entered date.I have to create the report and have the user enter the start AND the end date. The user enters the same date for both. My filters than are: is the on or before the entered start date and is on or after the entered end date.

Not a great solution, but it works.