topic Re: Truncate date field in Geoprocessing Questions

Truncate date field

ruchibhutani — Mon, 14 Jan 2013 22:26:24 GMT

Hello

I have an annexation layer that has Annex_Date field in mm/dd/yyyy format. I am trying to extract just the yyyy part. I have added a new field called Annexation_Year, and I am trying to calculate the records. I have tried to use DatePart and DateYear function for VBScript without any success. Any other suugestions on how this can be handled?

Thanks,
Ruchi Bhutani
GIS Analyst

Re: Truncate date field

JakeSkinner — Tue, 15 Jan 2013 10:18:03 GMT

Hi Ruchi,

You can do this using Python and the field calculator. Here is the syntax:

!Annex_Date![-4:]

Also, be sure 'Python' is checked at the top of the Field Calculator.

[ATTACH=CONFIG]20728[/ATTACH]

Re: Truncate date field

ruchibhutani — Tue, 15 Jan 2013 15:33:44 GMT

Thanks Jake...