First and Last use of a Place

[GenieBottle 0]

Hi!

I would like to create List of Places report that shows the first and last date that a place is used across all event types in my data set. Also, I would like to be able to filter the report. I would like the output columns to be as follows:

city, county, state, first date, last date

 

It would also be nice if there were a way to find the events that match this first date and last date.

 

I will use this report to research the local events that may have impacted my family.

 

Is it possible to do this?

Thanks!

Crystal

[Jim Byram 0]

Keep in mind that date is an event property, not a place property so you have to approach this on that basis.

 

You can run a List of Events report filtering for a given place and sort the output by the event dates.

 

List of Events

filter

Place Contains [?] END

(you will be prompted for the place text when the report runs)

 

And adjust the output columns as you wish and do the primary sort by the date.

[GenieBottle 0]

Jim,

This works great! Outputing the tag is helpful. It does generate a lot of pages, but I can get what I need by just viewing the first and last pages of the screen output without wasting paper.

Thanks,

Crystal