Change Type

Enables changing a column to a different data type.

The results can be output as Text, Integer (Whole Number), Decimal, Date and Time, Boolean.

Date & Time must be in one of the following formats:

• Date & Time must be in one of the following formats:

  • dd MMM yyyy HH:mm:ss.ff

    • 17 Dec 2022 20:42:32.23342

  • MM/dd/yyyy HH:mm:ss.ff

    • 12/17/2022 20:42:32.23342

  • yyyy.MM.dd HH:mm:ss.ff

    • 2022-12-17 20:42:32.23342

    • 2022-12-17T20:42:32.23342

  • The date separator can be ".", "-" or "/"

• Integer or Decimal must be in one of the following formats:

  • #.#

    • 1656 or 1656.5689 or 1,656.5689

  • -#.#

    • -1656 or -1656.5689 or -1,656.5689

  • (#.#)

    • (1656) or (1656.5689) or (1,656.5689)

  • The decimal separator must be a period (.)

  • The thousands separator must be a comma (,)

• Boolean must be one of the following values (case insensitive):

  • True / Yes / 1

  • False / No / 0