Field Calculator Format Function

OleksandrChubatyy — Mon, 24 Jun 2013 14:40:51 GMT

Hi

Format function in VB returns a type mismatch error.
The expression I am trying to execute is like this: Date_Str_Field = Format("06/24/2013", "dd-mm-yyyy").
Does not ArcMAp 10.1 support this function anymore?

Thanks

Re: Field Calculator Format Function

RichardFairhurst — Mon, 24 Jun 2013 15:08:25 GMT

Hi

Format function in VB returns a type mismatch error.
The expression I am trying to execute is like this: Date_Str_Field = Format("06/24/2013", "dd-mm-yyyy").
Does not ArcMAp 10.1 support this function anymore?

Thanks

Format is a VBA function, not a VB Script function and is no longer supported by ArcMap 10.1. VB script has a FormatDateTime function, but if the format does not match your regional settings, it is not at all easy to force the date into a custom format. You basically have to write all of the parsing and formatting steps yourself for each date component, which is tedious.

Python should be something like:

import datetime
Date_Str_Field = datetime.datetime.strptime('06/24/2013', '%m/%d/%Y').date().strftime('%d-%m-%Y')

topic Re: Field Calculator Format Function in Data Management Questions

Field Calculator Format Function

Re: Field Calculator Format Function