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