Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been having problems with the Convert Time Field tool. I am able to convert the date with no problem but the time is being deleted. One time it worked OK but then when I selected a subset of records and did an Export Data on the Shape file, the time part to the date field was deleted during the export. The input date string (as string) looks like this yyyy-MM-dd'T'HH:mm:ss'Z' I have tried both preset and custom string specifications. The log claims that the process was successful, but the result is not what I need.

share|improve this question

Shapefiles can't store datetime fields like this in their *.dbf attribute table. You may have better luck exporting to and/or storing your data in a Geodatabase which will support a more robust datetime. Check this thread for more information:

Presumably your output looks something like yyyyMMdd (8 bytes). If that is the case, then the assertion I made above and that is made in the linked thread is true. If the field is being written with null values the issue may be a bit more deep-seeded and require further delving.

Info on how a Date field is stored in a dBase *.dbf:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.