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
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.
Not a great solution, but it works.