Re: Month, day, year fields

["Bob Kohlndorfer" <bkohlndorfer@xxxxxxxxxx>]

You should also be careful of the practice of using values like all 9s that
may have had meaning, like no expiration date.  You cannot use invalid dates
for special meanings any more.

----- Original Message ----- 
From: <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, September 24, 2004 2:57 PM
Subject: Month, day, year fields


Is there any valid reason to design new files with these fields separated
out, in the physical?  Versus using a true date field?  The only
difficulty I see with a true date field is that you either have to learn
how to code a null indicator on your field, or use a default date.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.