Weekly Challenges

SeanAdams · ‎04-08-2017

:-) pretty simple but fun

mceleavey · ‎04-13-2017

I seem to remember this was part of the certification exam, although I might be wrong. I've slept since then.

I think my solution will pretty much the same as the others.

Anyway, pretty straightforward:

I first converted the EventFireDate field to datetime using the Date Parsing tool. I then ordered them sequentially by this date and created a multi-row formula to determine like-for-like records that had a difference of 30 seconds or less from the previous line.
Then I simply sorted it accordingly.

I first converted the EventFireDate field to datetime using the Date Parsing tool. I then ordered them sequentially by this date and created a multi-row formula to determine like-for-like records that had a difference of 30 seconds or less from the previous line.Then I simply sorted it accordingly.