- Immigration must be after they were born in England and before they died in America,
If a mother immigrated and baby was born in US, it must be before birth of baby,
While I am making assumptions, if married in America and baby born in America, it is likely after marriage date, etc.
Then when I export to Excel or other plotting software, I would plot a horizontal bar with earliest and latest date for each person. I plan to color code bars by country they came from. Then If I plot all this vs. time on x-axis, I have a timeline showing when surges of family immigration happened. I would then add events showing what was going on in their country of origin (etc.) so I could see patterns and drivers of immigration.
I think this will be very interesting for my kids/etc.
To do this, I need Excel file with 2 date columns.
I just tried exporting from standard “Immigration” field.
That field does allow Between 1620 and 1630, for example. But there are currently many date types that come out. I Parse by comma delimited. I can’t parse by space, as too many date formats.
I was thinking I could Copy “Immigration” and add a 2nd date field, so one is earliest date and one is latest date. But the Edit does not seem to allow a second date field.
I guess I can just go through all the records, probably a hundred, and do more of this manually. But was wondering if anyone else has tried having an event with 2 dates?