TMG-L Archives

Archiver > TMG > 2004-12 > 1103589264


From: "John Cardinal" <>
Subject: RE: [TMG] I am Confused
Date: Mon, 20 Dec 2004 19:34:24 -0500
In-Reply-To: <41C76663.1020601@cox.net>


Carlton Brooks wrote:
> I figured out that there must be to many reports to generate
> so it was hanging up.
>
> Here is what I want to do.
>
> I want to create a list of births, death, marriages, etc.
> using the date format of MM/DD/YYYY. In the LOP report it does not give me

> an option to change the date.
>
> If I export the file to Excel, the date comes through as text, and it
> considerably hard to manipulate.

Carlton,

Last time I checked, Excel could only handle dates from 1900 on. (That's
from memory.) So, TMG is putting the dates in the file, but Excel will only
convert the 1900 and up dates to it's date format.

You might consider using MS Access rather than Excel. Or, you could split
the field into 3 numbers: year, month, day, each in it's own column.

John


This thread: