4 Replies Latest reply: Oct 30, 2014 10:09 AM by anbu cheliyan RSS

    Question about only showing one date based on yes or no

    David Young

      I have the following table:

       

       

      What I want to show is EventID = 20, AlternateSchedule = no, and EventStartDate = 9/25/2014 and  EventID 780, AlternateSchedule = yes, and EventStartDate = 9/27/2014.

       

      I was reviewing the firstsortedvalue command but not sure if this will work. 

       

      Basically what happened is MasterScheduleID 1007 started out with two EventDates 9/25/2014 and 9/27/2014 from 3 - 4.  Then the time changed on the 9/27/2014 to 7 - 8 so I only want to show the 7 - 8 time. 

       

      Does this makes sense?

       

      Any help would be awesome.

       

      David