|
Posted by willem van deursen on June 13, 2005, 8:49 am
Please log in for more thread options
Hello Kathrin,
as I understand from your earlier mails, you use excel for input of data
and convert that file to dbf (or let ArcView make the conversion).
Converting date and time could lead to problems because its not really
clear how date and time is stored, and whether what you see is actual
data or formatted data.
A solution might be to add three columns in your XLS files, year, month
and day, which are filled with data calculated from your date column. So
year becomes =year(datecolumn), month becomes =month(datecolumn) and so
on. These newly created columns will be converted as simple integer
columns. Now import the whole table in ArcView and recreate your yymmdd
field from these new columns. This way you avoid exporting and importing
the field_date type.
Hope this helps
Willem van Deursen
Kathrin Luettmann wrote:
> Hello,
>
> the raw data I wish to analyse with animal movement in Arc View have a
> date information. The date format required by animal movement is
> "ddmmyy" and that is the format I have used. The dbf's and shp's show
> dates, but the program does not realize it as a date field and so no
> analysis concerning dates are possible. Looking in the "properties"
> information I found the date to be defined as "field_decimal" and not
> "field_date" as it should be. I don't know how to change this and would
> be more than happy for any hint!
> thank's kathrin
--
Willem van Deursen, The Netherlands
wvandeursen_nospam@nospam_carthago.nl
replace _nospam@nospam_ for @ to get a valid email address
www.carthago.nl
| 
XML Sitemap