AnsweredAssumed Answered

Performing a search on dates

Question asked by darryle on Jul 20, 2018
Latest reply on Jul 20, 2018 by darryle

I have around 700 records in a database. I have 1 field that holds a Ship Date and another field that holds a Return Date. I create random reports based on date ranges and all is well. Now my problem is I need to create the report on a date range and include records that have blank return dates if the ship date falls within the range I'm searching. So far everything I have tried produces the wrong results.

Outcomes