Forum Discussion
Jamesw0879
Mar 22, 2023Copper Contributor
Sorting Dates which include some before 1900
I am sorting Ancestry information that includes Birth dates. The dates sort correctly if they are newer than 1900. The dates that are older than 1900 aren't sorted. Marriage and Death dates have the ...
Jamesw0879
Mar 23, 2023Copper Contributor
I have 11000 records with 5000 dates before 1900. I understand you to say split the dates of the older dates into 3 columns (Year, Month, Day). I can then sort the three columns, but won't I have the same problem with all the Years before 1900? Some of my dates are just the Year.
- HansVogelaarMar 24, 2023MVP
In the formulas used to split the date, set Month and Day to 1 if there is only a year.