Automatic item format conversions

When an item is assigned an output value, the Map Designer will automatically convert an item with the same interpretation (either number, text, date, or time) from one presentation to another. For example, if you want to map an item that is a number and whose presentation is integer to an item that is also a number but whose presentation is decimal, the Map Designer will automatically convert it.

The Map Designer fills in missing information in date and time conversions in the following way:

To convert a number to text, a date or time, or vice versa, you must use a function to perform the conversion. For example, to convert a date to text, use the function DATETOTEXT.