3 Replies Latest reply on May 27, 2013 6:37 PM by JohnColburn

    Find if a date is between Start Date and End Date

    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