Hi John & Otto, The date digit is missing on the Edit screen (and thereafter on reports, but I don't use these as often). The Reasonableness check is a good idea but doesn't show up these errors. I have just checked and I have an ancestor showing up as born in 185 but dying in 1927 and it does not flag her up. I know some of the people with these errors have been in BK for many years without problems. Never mind, I will correct them as and when I come across them! Thanks again Ruth On 19/08/2019 21:04, John Steed wrote: > To Ruth Wilson > > If you go to Edit to view a date, is the last digit missing when you view it there? > > Or is it only missing when you are printing a Custom List where the length of the date field is limited? > > The program does not change a Date field in the database unless you used "Global Search and Replace" > > Anyway, one way to find bad dates is to run the report Other, Reasonableness Report. > > John Steed > > ________________________________ > From: Ruth Wilson via BK <bk@rootsweb.com> > Sent: Monday, August 19, 2019 5:56 PM > To: bk@rootsweb.com <bk@rootsweb.com> > Cc: Ruth Wilson <ruth.wilson7@ntlworld.com> > Subject: [BK] Check date errors > > Hello all, > > Is there a way to check for errors in dates? Somehow or other, a number > of my dates have lost the final digit in the year (so, 25 Dec 194). I > don't quite know when it happened so can't fathom out a reason, and I > don't think I have done anything major anyway! There seems to be an > extra space appearing between the month and year. If I could find a list > of the error dates, I could spend an evening checking up the exact year. > > Thanks > > Ruth > > _______________________________________________ > Remember - Use the Archives at https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Farchiver.rootsweb.com%2Fcgi-bin%2Fsearch&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=gkhognUQjYh23sW2SXSS8Kjk8%2Fm9spC9lrINmk29jxE%3D&reserved=0 > _______________________________________________ > Email preferences: https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbit.ly%2Frootswebpref&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=nptTxG5rNJ6XIDmqyIbxsWW7frVhUgK1g9sI5GScdLg%3D&reserved=0 > Unsubscribe https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.rootsweb.com%2Fpostorius%2Flists%2Fbk%40rootsweb.com&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=fs3VhMrKruZ9z4aC%2FTPvosfiXIkXf%2FbK3KE02p3rupw%3D&reserved=0 > Privacy Statement: https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fancstry.me%2F2JWBOdY&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=WjY4rMblYABUyRrwRUz5pU7CGJJbmB%2FzBFck1rT48aU%3D&reserved=0 Terms and Conditions: https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fancstry.me%2F2HDBym9&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=FjvqIrlhAU9A6CLMI17FYAWIZ30bLdmi7S5%2Bg48hOFE%3D&reserved=0 > Rootsweb Blog: https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Frootsweb.blog&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=bI6wbQsuFjyvo38%2BBIBvXVRSu%2F3y9s4jGBXocguQY94%3D&reserved=0 > RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community > > _______________________________________________ > Remember - Use the Archives at http://archiver.rootsweb.com/cgi-bin/search > _______________________________________________ > Email preferences: http://bit.ly/rootswebpref > Unsubscribe https://lists.rootsweb.com/postorius/lists/bk@rootsweb.com > Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 > Rootsweb Blog: http://rootsweb.blog > RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community
Ruth Here's how I would find them Create a report with the following BK# Name Born Died Buried CSV (comma separated variable) Export Then Import into Excel and sort on date column Look for bad dates & fix them Sort died column Look for bad dates & fix them Sort on the buried column Look for bad dates & fix them. Jim -----Original Message----- From: Ruth Wilson via BK <bk@rootsweb.com> Sent: Tuesday, August 20, 2019 5:46 AM To: bk@rootsweb.com Cc: Ruth Wilson <ruth.wilson7@ntlworld.com> Subject: [BK] Re: Check date errors Hi John & Otto, The date digit is missing on the Edit screen (and thereafter on reports, but I don't use these as often). The Reasonableness check is a good idea but doesn't show up these errors. I have just checked and I have an ancestor showing up as born in 185 but dying in 1927 and it does not flag her up. I know some of the people with these errors have been in BK for many years without problems. Never mind, I will correct them as and when I come across them! Thanks again Ruth On 19/08/2019 21:04, John Steed wrote: > To Ruth Wilson > > If you go to Edit to view a date, is the last digit missing when you view it there? > > Or is it only missing when you are printing a Custom List where the length of the date field is limited? > > The program does not change a Date field in the database unless you used "Global Search and Replace" > > Anyway, one way to find bad dates is to run the report Other, Reasonableness Report. > > John Steed > > ________________________________ > From: Ruth Wilson via BK <bk@rootsweb.com> > Sent: Monday, August 19, 2019 5:56 PM > To: bk@rootsweb.com <bk@rootsweb.com> > Cc: Ruth Wilson <ruth.wilson7@ntlworld.com> > Subject: [BK] Check date errors > > Hello all, > > Is there a way to check for errors in dates? Somehow or other, a > number of my dates have lost the final digit in the year (so, 25 Dec > 194). I don't quite know when it happened so can't fathom out a > reason, and I don't think I have done anything major anyway! There > seems to be an extra space appearing between the month and year. If I > could find a list of the error dates, I could spend an evening checking up the exact year. > > Thanks > > Ruth > > _______________________________________________ > Remember - Use the Archives at > https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Farchi > ver.rootsweb.com%2Fcgi-bin%2Fsearch&data=02%7C01%7C%7Cb513c974089b > 463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C6370 > 18341965920172&sdata=gkhognUQjYh23sW2SXSS8Kjk8%2Fm9spC9lrINmk29jxE > %3D&reserved=0 _______________________________________________ > Email preferences: > https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbit.l > y%2Frootswebpref&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce940 > 7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172& > sdata=nptTxG5rNJ6XIDmqyIbxsWW7frVhUgK1g9sI5GScdLg%3D&reserved=0 > Unsubscribe > https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist > s.rootsweb.com%2Fpostorius%2Flists%2Fbk%40rootsweb.com&data=02%7C0 > 1%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaa > aaaa%7C1%7C0%7C637018341965920172&sdata=fs3VhMrKruZ9z4aC%2FTPvosfi > XIkXf%2FbK3KE02p3rupw%3D&reserved=0 > Privacy Statement: > https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fancs > try.me%2F2JWBOdY&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce940 > 7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172& > sdata=WjY4rMblYABUyRrwRUz5pU7CGJJbmB%2FzBFck1rT48aU%3D&reserved=0 > Terms and Conditions: > https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fancs > try.me%2F2HDBym9&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce940 > 7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172& > sdata=FjvqIrlhAU9A6CLMI17FYAWIZ30bLdmi7S5%2Bg48hOFE%3D&reserved=0 > Rootsweb Blog: > https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Froots > web.blog&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df > 9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=bI > 6wbQsuFjyvo38%2BBIBvXVRSu%2F3y9s4jGBXocguQY94%3D&reserved=0 > RootsWeb is funded and supported by Ancestry.com and our loyal > RootsWeb community > > _______________________________________________ > Remember - Use the Archives at > http://archiver.rootsweb.com/cgi-bin/search > _______________________________________________ > Email preferences: http://bit.ly/rootswebpref Unsubscribe > https://lists.rootsweb.com/postorius/lists/bk@rootsweb.com > Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: > https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog > RootsWeb is funded and supported by Ancestry.com and our loyal > RootsWeb community _______________________________________________ Remember - Use the Archives at http://archiver.rootsweb.com/cgi-bin/search _______________________________________________ Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/bk@rootsweb.com Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community
Thanks, Jim, that's an excellent idea! It didn't work perfectly, but it was a lot easier to scroll down and spot the 'odd' years quickly. Ruth On 20/08/2019 12:08, Jim Dell via BK wrote: > Ruth > Here's how I would find them > Create a report with the following > BK# > Name > Born > Died > Buried > CSV (comma separated variable) > > Export > Then Import into Excel and sort on date column > Look for bad dates & fix them > Sort died column > Look for bad dates & fix them > Sort on the buried column > Look for bad dates & fix them. > > Jim > > -----Original Message----- > From: Ruth Wilson via BK <bk@rootsweb.com> > Sent: Tuesday, August 20, 2019 5:46 AM > To: bk@rootsweb.com > Cc: Ruth Wilson <ruth.wilson7@ntlworld.com> > Subject: [BK] Re: Check date errors > > Hi John & Otto, > > The date digit is missing on the Edit screen (and thereafter on reports, but I don't use these as often). The Reasonableness check is a good idea but doesn't show up these errors. I have just checked and I have an ancestor showing up as born in 185 but dying in 1927 and it does not flag her up. I know some of the people with these errors have been in BK for many years without problems. > > Never mind, I will correct them as and when I come across them! > > Thanks again > > Ruth > > On 19/08/2019 21:04, John Steed wrote: >> To Ruth Wilson >> >> If you go to Edit to view a date, is the last digit missing when you view it there? >> >> Or is it only missing when you are printing a Custom List where the length of the date field is limited? >> >> The program does not change a Date field in the database unless you used "Global Search and Replace" >> >> Anyway, one way to find bad dates is to run the report Other, Reasonableness Report. >> >> John Steed >> >> ________________________________ >> From: Ruth Wilson via BK <bk@rootsweb.com> >> Sent: Monday, August 19, 2019 5:56 PM >> To: bk@rootsweb.com <bk@rootsweb.com> >> Cc: Ruth Wilson <ruth.wilson7@ntlworld.com> >> Subject: [BK] Check date errors >> >> Hello all, >> >> Is there a way to check for errors in dates? Somehow or other, a >> number of my dates have lost the final digit in the year (so, 25 Dec >> 194). I don't quite know when it happened so can't fathom out a >> reason, and I don't think I have done anything major anyway! There >> seems to be an extra space appearing between the month and year. If I >> could find a list of the error dates, I could spend an evening checking up the exact year. >> >> Thanks >> >> Ruth >> >> _______________________________________________ >> Remember - Use the Archives at >> https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Farchi >> ver.rootsweb.com%2Fcgi-bin%2Fsearch&data=02%7C01%7C%7Cb513c974089b >> 463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C6370 >> 18341965920172&sdata=gkhognUQjYh23sW2SXSS8Kjk8%2Fm9spC9lrINmk29jxE >> %3D&reserved=0 _______________________________________________ >> Email preferences: >> https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbit.l >> y%2Frootswebpref&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce940 >> 7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172& >> sdata=nptTxG5rNJ6XIDmqyIbxsWW7frVhUgK1g9sI5GScdLg%3D&reserved=0 >> Unsubscribe >> https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist >> s.rootsweb.com%2Fpostorius%2Flists%2Fbk%40rootsweb.com&data=02%7C0 >> 1%7C%7Cb513c974089b463baa9608d724ce9407%7C84df9e7fe9f640afb435aaaaaaaa >> aaaa%7C1%7C0%7C637018341965920172&sdata=fs3VhMrKruZ9z4aC%2FTPvosfi >> XIkXf%2FbK3KE02p3rupw%3D&reserved=0 >> Privacy Statement: >> https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fancs >> try.me%2F2JWBOdY&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce940 >> 7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172& >> sdata=WjY4rMblYABUyRrwRUz5pU7CGJJbmB%2FzBFck1rT48aU%3D&reserved=0 >> Terms and Conditions: >> https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fancs >> try.me%2F2HDBym9&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce940 >> 7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172& >> sdata=FjvqIrlhAU9A6CLMI17FYAWIZ30bLdmi7S5%2Bg48hOFE%3D&reserved=0 >> Rootsweb Blog: >> https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Froots >> web.blog&data=02%7C01%7C%7Cb513c974089b463baa9608d724ce9407%7C84df >> 9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018341965920172&sdata=bI >> 6wbQsuFjyvo38%2BBIBvXVRSu%2F3y9s4jGBXocguQY94%3D&reserved=0 >> RootsWeb is funded and supported by Ancestry.com and our loyal >> RootsWeb community >> >> _______________________________________________ >> Remember - Use the Archives at >> http://archiver.rootsweb.com/cgi-bin/search >> _______________________________________________ >> Email preferences: http://bit.ly/rootswebpref Unsubscribe >> https://lists.rootsweb.com/postorius/lists/bk@rootsweb.com >> Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: >> https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog >> RootsWeb is funded and supported by Ancestry.com and our loyal >> RootsWeb community > _______________________________________________ > Remember - Use the Archives at http://archiver.rootsweb.com/cgi-bin/search > _______________________________________________ > Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/bk@rootsweb.com > Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community > > _______________________________________________ > Remember - Use the Archives at http://archiver.rootsweb.com/cgi-bin/search > _______________________________________________ > Email preferences: http://bit.ly/rootswebpref > Unsubscribe https://lists.rootsweb.com/postorius/lists/bk@rootsweb.com > Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 > Rootsweb Blog: http://rootsweb.blog > RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community