# 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