Find records between two date fields
Hi I have a table that has an "Assigned Date" field and a "Projected Finish" field. Both are date fields. I would like to make a report that has the user select a date and all the records are displ...
Forum Discussion
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
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