4 Replies Latest reply on Aug 11, 2006 7:50 AM by Karen_Little

    Multiple dates for event posting

      I'm creating an application where a person can post an event with listings for up to 20 days from filling in the form. I'm saving these dates (one to twenty individual units, using a 20060810-type code, separated by a delimiter) in a single field.

      I am trying to figure out how I can construct an efficient query to find a range within a set of date codes that answers the question "what is happening between 8/1 and 8/6" for example. I know how to find things by the day, of course.

      Is this possible?