Question about only showing one date based on yes or no
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.