UFO sighting: Trade Area

[Virender]

Hi All,

I am practicing for Alteryx advanced certification. I am referring the preparation guide. Where I am not able to understand the solution of practical question.

Prepration Guide: https://s3-us-west-1.amazonaws.com/ayx.policies/Advanced+Certification+Exam+Prep+Guide.pdf

Question: You are investigating recent UFO activity in Colorado. Given the
provided dataset on UFO sightings in Colorado, determine the number
of reported sightings that happened within 5 miles and 10 minutes of
another sighting. (Hint: Count each sighting individually. If two
sightings are within the required distance and time of one another, both
sightings count towards the total). 

Please help me to understand the solution.

Thanks

[Lorco]

Joshua, I had the exact same error, Literally had to go through block by block to figure out what I was doing wrong!

Does anyone know why mm isn't a valid month format ?!

[geraldngugi]

Here are my 2 solutions