Use conversion functions at data boundaries: imported text, integration values, locale-specific numbers and dates, and calculated text shown to a client.
Formats a number, date, time, or timestamp as client-facing text.
- Syntax:
Format(value[, pattern[, unitOrCulture[, culture]]])
- Requires: a numeric, date, time, or timestamp value. Number formatting accepts an optional pattern, unit, and culture. Date/time/timestamp formatting accepts a pattern and optional culture.
- Returns: Text.
- Best for: totals, units, percentages, dates, and times shown in forms or print output.
Culture values use language tags such as en-ZA, en-US, or de-DE. A number pattern can also use standard forms such as N2, F2, P1, C2, or E3.
ToBoolean
Converts a boolean, number, text value, or null into a boolean.
- Syntax:
ToBoolean(value)
- Requires: a boolean, numeric, or text value. Non-zero numbers are true. Text is true only for
1, true, or yes, ignoring case and surrounding spaces. null is false.
- Returns: Boolean.
- Best for: normalising imported flags before a condition.
ToDate
Converts text to a date, or selects the local calendar date represented by a timestamp.
- Syntax:
ToDate(text[, culture]) or ToDate(timestamp[, timeZone])
- Requires: text or a timestamp. Text can include a culture such as
en-GB; timestamps can include a timezone such as Africa/Johannesburg or GMT+02:00.
- Returns: Date.
- Best for: imported dates and timezone-aware integration timestamps.
ToNumber
Converts text or a boolean into a number.
- Syntax:
ToNumber(value[, culture])
- Requires: text, boolean, numeric, or
null. The optional culture controls decimal and grouping separators. true becomes 1, false and null become 0.
- Returns: Numeric.
- Best for: CSV, API, or user-entered numbers that arrive as text.
ToText
Prints a supported value as text using TeamDesk-compatible forms.
- Syntax:
ToText(value)
- Requires: text, numeric, boolean, date, time, timestamp, duration, user, or
null.
- Returns: Text, or
null when the input is null.
- Best for: explicitly converting a value before joining or sending it.
Numbers are printed with six decimal places, booleans as 1 or 0, and users by display name. Use Format when the presentation needs a specific pattern or culture.
ToTimeOfDay
Converts text to a time of day, or selects the local time represented by a timestamp.
- Syntax:
ToTimeOfDay(text[, culture]) or ToTimeOfDay(timestamp[, timeZone])
- Requires: text or a timestamp, plus an optional culture/timezone appropriate to that input.
- Returns: Time.
- Best for: imported appointment times and timezone-aware response timestamps.
ToTimestamp
Combines a date, optional time, and optional timezone into one timestamp.
- Syntax:
ToTimestamp(date[, time[, timeZone]])
- Requires: a date; optional time defaults to midnight and optional timezone defaults to the current formula timezone.
- Returns: Timestamp.
- Best for: creating an exact moment from separate date and time fields.
Convert at the edge of a formula, then keep the resulting value typed while you calculate.
