AnsweredAssumed Answered

date range calculation help

Question asked by ericjlindholm on Jan 16, 2013
Latest reply on Jan 17, 2013 by philmodjunk

Title

date range calculation help

Post

     I have a table of events.  They all have a start and end date.  Some are single days and some are multiple.  I would like to view a summary of one day and see the names of all the events that have a date in between or including the start and end date.

      

     Table example

     Event 1:  Start Jan 1 2013 , End Jan 3 2013

     Event 2:  Start Jan 2 2013, End Jan 2 2013

     Event 3: Start Jan 2 2013, End Jan 3 2013

      

     Would display like:

      

     Jan 1:  Event 1

     _________________

     Jan 2:  Event 1

                  Event 2

                  Event 3

     ___________________

     Jan 3:  Event 1

                  Event 3

      

      

     THANK YOU!

Outcomes