AnsweredAssumed Answered

Find if a date is between Start Date and End Date

Question asked by JohnColburn on May 26, 2013
Latest reply on May 27, 2013 by JohnColburn

Title

Find if a date is between Start Date and End Date

Post

     I have a global date: G_Date.

     I have a table, "trips" with with trip_name, start_date and end_date fields.

     I would like to find which record (if any) in the "trips" table where G_date is part of the range between start_date and end_date. 

     If I create a related table linked with "trip_name", and auto create a record for each date within the start_date - end_date range of the parent table, I should then be able to search on that.

     It seems there should be an easier way to accomplish this. I would like to just do a find on the trip table, but I can't figure how to do it.

     Any suggestions would be much appreciated.

     Thanks.

     John

      

Outcomes