String Formatted Date Fields to Date Field

[cosbyr]

Expose option in field mapping UI area to allow user to specify the input date string format (ie yyyy/mm/dd, or mm-dd-yy, etc) and handle translation to a date field on the target dataset

[pLeBlanc93]

Two approaches:

• Convert Time Field GP tool
• core python strptime

Neither is very straightforward from a UI perspective since both can support data conversion from a variety of datatypes.

[cosbyr]

@pLeBlanc93 Noted. I think we would have to create some Custom UI that would use either core python or or the Convert Time GP tool as the underlying conversion technology. I lean towards core python because the Convert Time GP tool creates extra fields in the process. Would be nice to not have to worry about cleaning those up.