Converting Data Field Types with Functions

Each column in a Spectrum Workbook is assigned a specific data type. Particular criteria is required for data to fall into a data type category. When using your data within Workbooks, certain Spectrum functions only work with certain types of data. Also, certain functions return only a specific type of data.

These data types aren't fixed and can be changed within a Workbook to fit your needs.

Convert Data Type Functions

Original data type	Desired data type	Function
String	Integer	INT
String	Float	FLOAT
String	Date	ASDATE
Integer	String	T
Integer	Date	MSTODATE
Integer	Big Integer	BIGINTEGER
Integer	Big Float	BIGDECIMAL
Float	Integer	INT
Float	String	T
Float	Big Integer	BIGINTEGER
Float	Big Float	BIGDECIMAL
Date	String	FORMATDATE
Date	Integer	TIMESTAMP
List	String (JSON)	TOJSON
Any type	List	LIST