* Sorting of dates

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
E Wilcock
Megastar
Posts: 1011
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Sorting of dates

Post by E Wilcock » 13 Aug 2020 13:32

Can someone please help me or comment on date sorting in fh?

I am working on a data base which includes men of military age in World War 2. I currently have query results showing me this group with birth dates and places and death dates and places in columns.
But sorting on those dates is strange.

Those who died in WW2 in Europe without a known date of death I enter the date as "before 8 May 1945". Those who did not die in the war or soon after (from wounds) I mark after 1945.
Using the words before and after creates havoc with the sorting.
Any entries for "after 1945" come higher in the order than dates before June 1945 because after starts with A and comes earlier in the alphabet than before.

I would like to correct the entry so I get war dead above survivors

User avatar
tatewise
Megastar
Posts: 18909
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Sorting of dates

Post by tatewise » 13 Aug 2020 14:45

It is not the after or before that is affecting the sorting, but that dates with only a year default to 1 January.
So after 1945 is effectively saying after 1 Jan 1945 and thus sorts before every other date in 1945.

Change to using after 9 May 1945 and all will sort well.

If you have a great many dates to change then use the Search and Replace plugin.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
E Wilcock
Megastar
Posts: 1011
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: Sorting of dates

Post by E Wilcock » 13 Aug 2020 15:11

Thank you Mike. Will do.

Post Reply