|
|
|
|
Customers
GenoPro version: 3.1.0.1
Last Login: Friday, March 18, 2022
Posts: 5,
Visits: 27
|
I have noticed some of my dates of birth have changed by 13 days? My own date of birth changed to 13 days earlier than originally entered, then I noticed others had changed?? If I go to Table Layout and then Individuals the chart shows 2 columns "Date of Birth" and "Birthday" and where a date of birth has been entered in the FT there are 13 days difference between the columns in all of them. Have I done something? or is there a bug?? as I don't see where I can control the difference in the columns of data by 13 days??
|
|
|
|
|
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: 4 hours ago
Posts: 1,580,
Visits: 31,512
|
Not a problem here. The date of Birth shows day, month, year and Birthday shows the same day & month.
This also seems odd in that the data stored is the first complete data and Birthday seems to calculated from that by omitting year. Export to xml and see if anything shows up
|
|
|
|
|
Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: 6 hours ago
Posts: 3,393,
Visits: 26,099
|
Sounds as if you have inadvertently set your dates to be on the Julian Calendar instead of the Gregorian one. To rectify, pull up the Properties of any individual with a date, right click on that date and choose Gregorian.
'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
|
|
|
|
|
Customers
GenoPro version: 3.1.0.1
Last Login: Friday, March 18, 2022
Posts: 5,
Visits: 27
|
Thanks very much, I just have to change the dates as they are all now 13 days too late, but both columns in the table are consistent. Is there a way to change all of the dates backwards by 13 days as a block rather than change each one in turn?? Again Thanks
|
|
|
|
|
Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: 6 hours ago
Posts: 3,393,
Visits: 26,099
|
Unfortunately if you have entered new (Gregorian) dates whilst in Julian calendar mode then when you switch to Gregorian these dates will be wrong as youy have discovered.If you have access to MS Excel you can copy a column of dates from Table Layout view (select first date, then right click and chose Copy Column) into an Excel spreadsheet and adjust the dates there using a fomula and then paste the results back. If you have partial dates e.g. just year or month and year then You may need to check for valid dates in Excel. This can be done with a user function (e.g. see http://www.vbaexpress.com/kb/getarticle.php?kb_id=323
Function IsADate(cel) As Boolean
IsADate = IsDate(cel)
End Function |
) and then use formula =IF(IsADate(A1), A1-13,A1)
'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
Edited: Thursday, January 7, 2010 by
Ron
|
|
|
|
|
Customers
GenoPro version: 3.1.0.1
Last Login: Friday, March 18, 2022
Posts: 5,
Visits: 27
|
Great , thank you very much, it works fine. Amazing what can be done when you know how !! Best regards Tony
|