Field type to use when data contains invalid dates 
Author Message
 Field type to use when data contains invalid dates

Randy: changing the date fields to alphas will create
more reporting problems than it solves.. why not just
"fill-in" the incomplete dates to some extent?

If you have mm/yy, make it mm/01/yy.. if you have
"summer 1954", change it to 7/1/54.. etc..

--
Steve Green - Diamond Software Group - Waldorf Maryland USA
CompuServe 71333.2362 -- I am a member of Corel's CTech and
Borland's TeamB Tech Support staffs, but I do not represent
Corel or Borland International in any official capacity.



Sun, 30 May 1999 03:00:00 GMT
 Field type to use when data contains invalid dates

Quote:

>I've been given the task of converting several legacy databases.  Each
>databases contains a "Date of observation" field.  These are wildlife
>observations that go back many years.  In all cases, some records
>contain invalid dates.  For example, the person saw a black bear
>during the summer of 1954 or went out in June but never recorded the
>date.
>My supervisor has pointed how important these observations are given
>the lack of data for some species.  It looks as if my only chose for
>field type is alpha.  Any ideas / suggestions?

Include a second field, noting whether the date field is exact or not.
Then if it's summer 54, write soemthing like 06/01/96 (June), then in
the exact/not field put No.

======================================================================
Kasey K. S. Chang (a guy)             Paradox for Windows Programmer

http://userwww.sfsu.edu/~kschang      X-COM Guru  among other things
----------------------------------------------------------------------
Enter Star Trek Nexus -- the PREMIER Guide to Star Trek on Internet!



Wed, 02 Jun 1999 03:00:00 GMT
 Field type to use when data contains invalid dates

Quote:


> >I've been given the task of converting several legacy databases.  Each
> >databases contains a "Date of observation" field.  These are wildlife
> >observations that go back many years.  In all cases, some records
> >contain invalid dates.  For example, the person saw a black bear
> >during the summer of 1954 or went out in June but never recorded the
> >date.
> >My supervisor has pointed how important these observations are given
> >the lack of data for some species.  It looks as if my only chose for
> >field type is alpha.  Any ideas / suggestions?

> Include a second field, noting whether the date field is exact or not.
> Then if it's summer 54, write soemthing like 06/01/96 (June), then in
> the exact/not field put No.

> ======================================================================
> Kasey K. S. Chang (a guy)             Paradox for Windows Programmer

> http://userwww.sfsu.edu/~kschang      X-COM Guru  among other things
> ----------------------------------------------------------------------
> Enter Star Trek Nexus -- the PREMIER Guide to Star Trek on Internet!

You could also try adding a field that contains the margin of error in
days. For example, the June observation would have the date 6/1/?? (I
assume you know or can pin point the year) and the margin field would
contain "30" or the summer of '54 becomes "6/1/54" and "90".

Good luck!
--
Albert P.Franco II

Centracero S.A.
Ctra. Estella S/N
31280 Murieta Navarra Spain
34 (48) 53 40 92
Spanish or English texts ok



Wed, 09 Jun 1999 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Query datetime-field by date when field contains date + time

2. ADO Text Driver forces Numeric Type on field containing string and numeric data

3. To add a field of the type Dates with a field of the Whole type

4. Date data type error when using data form wizard in VB5

5. error 3259 Invalid Field Data Type

6. newbie Runtime error 3259: Invalid Field Data Type

7. Invalid Data Field Type

8. Comparing datetime field (containing date, time values) to a date only string

9. How to handle invalid date in Converting Text to Date Field

10. GROUP BY on a field of data type date/time

11. null value in a field data type as date


 
Powered by phpBB® Forum Software