ValueFormat

The <ValueFormat> element converts field or attribute values from one format to another.

Attribute Description
format The input format.
targetformat The target format, when you set type to customdate.
type

The data format to standardize on. You can specify:

  • autndate, to convert into the IDOL Server AUTNDATE format.
  • customdate, to convert into a custom format specified by the targetformat attribute.

The following example changes the format of a field named "dateField", from a value such as 2020-10-27 15:11:32 to AUTNDATE format.

<FieldStandardization>
    <Field name="dateField">
         <ValueFormat format="YYYY-MM-DD HH:NN:SS" type="autndate" />
    </Field>
</FieldStandardization>