Timestamp1 is to the 100th millisecond, if I could get the timestamp to the nearest second rather than the 100th of a second that might work. I tried date(Timestamp1, 'mm/DD/yyyy') as newDate but Qlikview seemed to remember the "rest" of the date - I need to check this. Whether the conversion is just "looks" or if the number is actually changed. Will check on Monday.
Max Dreamer - is there a way of keeping the timestamp to the nearest minute? In another situation I have a series of events that occur within a number of milliseconds of each other. I want to group them together if they occur within the same minute. I will start another discussion.