GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 
Problem between Date of Birth and Birthday in Table Layout, Individuals?


https://support.genopro.com/Topic25198.aspx
Print Topic | Close Window

By 617008 - Tuesday, January 5, 2010
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??

By appleshaw - Tuesday, January 5, 2010
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
By genome - Tuesday, January 5, 2010
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.
By 617008 - Wednesday, January 6, 2010
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

By genome - Thursday, January 7, 2010
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)

By 617008 - Thursday, January 7, 2010
Great , thank you very much, it works fine.

Amazing what can be done when you know how !!

Best regards

Tony