GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum




Problem between Date of Birth and Birthday in Table Layout,...

Click to view RSS...
Author 13 days between DOB and Birthday ?
Posted Tuesday, January 5, 2010 - Post #25198
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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??

Posted Tuesday, January 5, 2010 - Post #25200
Grand Master

Grand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand MasterGrand Master

Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 3 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
Posted Tuesday, January 5, 2010 - Post #25201
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 5 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"
Posted Wednesday, January 6, 2010 - Post #25215
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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

Posted Thursday, January 7, 2010 - Post #25219
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: 5 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
Posted Thursday, January 7, 2010 - Post #25227
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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



Similar Topics

Click to view RSS...
Expand / Collapse

Reading This Topic

Expand / Collapse