ArcMap: Fighting with Date/Time Fields

Convert date-field (as String) to Date (as Date field) – Update ArcGIS 10

Datefield = format ([date_string_field], "dd-mm-yyyy")

Convert date-field (as date) to string (ArcGIS 10)

DatePart ( "yyyy", [UTC_DATE] ) & "-" & DatePart ( "m", [UTC_DATE] ) & "-" & DatePart ( "d", [UTC_DATE] ) = yyyy-m-d