ConvertDate
 
Description

Allows you to convert a date in the ImportFieldOpApplyTo<N> field from one format to another.

Use ImportFieldOpParam<N> to specify the source and target formats as follows:

ImportFieldOpParam<N>=<convert_from>:<convert_to>

<convert_from>
Enter the source format for the date in the field.

<convert_to>
Enter the target format to which to convert the date.

Example

ImportFieldOp0=ConvertDate
ImportFieldOpApplyTo0=Date
ImportFieldOpParam0=YYYY/MM/DD;MM/DD/YY

In this example, the date in the Date field is converted from YYYY/MM/DD to MM/DD/YY. That is, if the value of the Date field is 2002/11/01, it is imported as 11/01/02.