Date+Formats

=Date Formats=

Within the RootsMagic 4 database, several date-related fields exist. These fields can be grouped into into four different storage types:

__FLOAT, with the integer part representing number of days since 1899 Dec 31 and fractional part representing time of day__ EventTable - EditDate LinkTable - extDate (presumably) NameTable - EditDate (presumably) PersonTable - EditDate (actually effectively INTEGER stored as FLOAT, meaning representing number of days since 1899 Dec 31)

__INTEGER, 64-bit position-coded starting 10000BC__ EventTable - SortDate //see Dates> SortDate Algorithm// MediaLinkTable - SortDate NameTable - SortDate ResearchTable - SortDate1 ResearchTable - SortDate2 ResearchTable - SortDate3

__INTEGER, representing calendar year (yyyy)__ NameTable - BirthYear NameTable - DeathYear

__TEXT, represented by format explained in the Date sheet within__ EventTable - Date MediaLinkTable - Date NameTable - Date ResearchTable - Date1 ResearchTable - Date2 ResearchTable - Date3