Date Formats

There are 15 different qualifiers that apply to all dates, although only 6 of these are normally used in reports. The 6 that can be used in reports are:

Date formats get more and more abbreviated as you move down this list. The most abbreviated format is Abbrev(4).

The other qualifiers are

Of these, the last 3 have a special role in that they are designed to be used together, when copying date information from a query result set, into another program such as a spreadsheet or database program.

There are also 3 other qualifiers which can only be used with some dates, which give a person's age at the date in question. These qualifiers are not discussed here.

To illustrate the function of all of the listed qualifiers, 12 different sample dates, all valid date types in Family Historian, are shown below in LONG format. Then, for each date, the same data is shown displayed in each of the other formats in turn.

The 10th example is that of a "date phrase". The 11th is an interpreted date phrase. The 12th is a blank date.

LONG Format

1 15 December 1989
2 15 December 1989 (estimated)
3 15 December 1989 (approx)
4 From 12 June 1908 To 14 December 1919
5 From 12 June 1908
6 To 12 June 1908
7 Between 12 June 1908 and 14 December 1919
8After 12 June 1908
9Before 12 June 1908
10"after wife died"
1112 September 1929 ("after wife died")
12 

COMPACT Format

1 15 Dec 1989
2 15 Dec 1989 (est)
3 15 Dec 1989 (app)
4 Frm 12 Jun 1908 To 14 Dec 1919
5 Frm 12 Jun 1908
6 To 12 Jun 1908
7 Btw 12 Jun 1908 and 14 Dec 1919
8 Aft 12 Jun 1908
9 Bef 12 Jun 1908
10 "after wife died"
11 12 Sep 1929 ("after wife died")
12 

ABBREV Format

1 15 Dec 1989
2 15 Dec 1989 (est)
3 15 Dec 1989 (app)
4 Frm 1908 To 1919
5 Frm 1908
6 To 1908
7 Btw 1908 and 1919
8 Aft 1908
9 Bef 1908
10  
11 12 Sep 1929 (int)
12  

ABBREV2 Format

115 Dec 1989
215 Dec 1989?
315 Dec 1989?
41908-1919
51908-_____
6____-1908
71908-1919
8Aft 1908
9Bef 1908
10____
1112 Sep 1929?
12____

ABBREV3 Format

In the example below, the date is displayed in dd/mm/yyyy format which is the normal 'localised' short form date format for the U.K. and elsewhere. In the U.S., the normal equivalent date format would be mm/dd/yyyy and this format would be used instead. So, for example, in the U.S., date no. 1 would usually display as 12/15/1989.

1 15/12/1989
2 15/12/1989?
3 15/12/1989?
4 1908-1919
5 1908-
6 -1908
7 1908-1919
8 Aft 1908
9 Bef 1908
10 
1112/9/1929?
12 

ABBREV4 Format

1 1989
2 1989?
3 1989?
4 1908-1919
5 1908-
6 -1908
7 1908-1919
8 Aft 1908
9 Bef 1908
10 
111929?
12 

The next 5 date formats are all applicable to simple dates only, and return nothing where a date range or a date period is used.

DAY Format

1 15
2 15
3 15
4  
5  
6  
7  
8  
9  
10 
1112
12 

MONTH_NUMBER Format

1 12
2 12
3 12
4  
5  
6  
7  
8  
9  
10 
119
12 

MONTH_NAME Format

1December
2December
3December
4 
5 
6 
7 
8 
9 
10 
11September
12 

MONTH_AND_DAY Format

In the example below, the Day is displayed before the Month. If your PC is configured to display months before days in a short format date format (which typically it would be in the U.S.), the Month would appear first...

115/12
215/12
315/12
4 
5 
6 
7 
8 
9 
10 
1112/9
12 

YEAR Format

11989
21989
31989
4 
5 
6 
7 
8 
9 
10 
111929
12 

 

The last 3 formats, XDATE1, XDATE2 and XDATETYPE are all designed to be used together. The problem they are designed to overcome is that Family Historian supports more complex date information than can be accommodated in date fields within most spreadsheet or database programs. By moving Family Historian's date information into 3 fields, it becomes easier to export the data in a way that lets them be used effectively within spreadsheets or database programs (the 'X' stands for 'eXport'). A typical use of these fields would be within a query. The data from the query can then be copied and pasted into a spreadsheet.

It is easier to see how the 3 fields work together if they are shown together in one table:

  XDATE1 XDATE2 XDATETYPE
115 Dec 198915 Dec 1989Date
215 Dec 198915 Dec 1989Estimate
315 Dec 198915 Dec 1989Approx
412 Jun 190814 Dec 1919From/To
512 Jun 1908 From
6 12 Jun 1908To
712 Jun 190814 Dec 1919Between
812 Jun 1908 After
9 12 Jun 1908Before
10  Phrase
1112 Sep 192912 Sep 1929Interpreted Phrase
12   
The CHM file was converted to HTML by chm2web software.