Dear all, I need help on this, hoping its possible
Start Date *Time Stamp1
End Date *TimeStamp2
I would like to get the values of End Date (TimeStamp 2) taking into consideration that the values of TimeStamp2 are dependent on the valueTime Stamp1 of the next row and are same values only that they are values of the the second Row.
SO basically the first value of Row 1 TimeStamp2 would be 12/2/2012 12:01:21 provided the ID "2" is the one that comes next after ID "1"
Hi Mark, am not sure if the table is in Reverse, if we take it the way you suggest, then it will populate End that belongs to Name1 with values that belong to Name2, for example where ID is C in the previous table i have provided, yet END for ID C is supposed to be empty as Name1 didnt have any activity following ID C