Convert between Data Types - Anaplan Technical Documentation

Some Functions are specifically for converting the type of data to allow it to be used in a different context, for example, using a number in a text-only cell. See Converting a number to a Date in Formula Usage Tips.

Use the table below to quickly reference the available functions.

Convert From	Convert to	Function
Number	Text	TEXT()
	Date	Refer to Formula Usage Tips - Converting a number to a Date
Date	Number	DAY() MONTH() YEAR()
	Time-formatted List Item	PERIOD()
Time-formatted List Item	Number	MONTH() YEAR()
	Time-formatted List Item	ITEM()
	Text	CODE() NAME()
List Item	List Item	ITEM()
	Text	CODE() NAME()
Text	Number	VALUE()
	Date	DATE()
	Time-formatted List Item	FINDITEM()
	List Item	FINDITEM()