I have timestamps for events stored as datetime's. Given a starting datetime, is there a way to find the block of timestamps where:
1. At least one timestamp is within 1 hour of the given datetime.
2. No individual timestamp is greater than 1 hour after the previous timestamp (or possibly before the next timestamp if that's easier...or both if necessary).
Basically, I'm trying to find a block of activity where the exact start and end time is uncertain.
December 7, 2007 7:45 AM
December 11, 2007 10:51 PM