Savant

<code>value</code>: The value you want to convert to text. This can be a datetime, number, or any other compatible data type.

format: (Optional) A parameter specifying the desired text format for the datetimes or the number. If not provided, a default format is used.

1. <code>value</code>: The value you want to convert to text. This can be a datetime, number, or any other compatible data type.
2. format: (Optional) A parameter specifying the desired text format for the datetimes or the number. If not provided, a default format is used.

Converts a value, whether it's a datetime or any other data type, to a text format

TO_TEXT

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	The `TO_TEXT()` function is a versatile function used to convert various data types, including datetimes, into text format. This is beneficial when you need to display or manipulate data in text form, such as custom date formatting or converting non-text values to text.
Syntax	TO_TEXT(`value`), TO_TEXT(`datetime`, “[format]”)

Symbol	Description
y	Replaced by the year. Normally the length specifies the padding, but for two letters it also specifies the maximum length.
Y	Same as y but uses the ISO year-week calendar. ISO year-week increments after completing the last week of the year. Recommend use with the w symbol.

Symbol	Description
Q	Use one or two for the numerical quarter, three for the abbreviation, or four for the full name.
q	Use one or two for the numerical quarter, three for the abbreviation, or four for the full name.

Symbol	Description
M	Use one or two for the numerical month, three for the abbreviation, or four for the full name, or five for the narrow name.
L	Use one or two for the numerical month, three for the abbreviation, or four for the full name, or five for the narrow name.

Symbol	Description
w	Week of year according to the ISO year-week calendar. This may have 52 or 53 weeks depending on the year. Recommend use with the Y symbol.
W	Week of month.

Variables

Date Fields

Time and Timzone Fields

Symbol	Description
G	Replaced with the era string for the current date. One to three letters for the abbreviated form, four letters for the long form, five for the narrow form.

Symbol	Description
d	Day of month.
D	Day of year.
F	Day of week in month.

Symbol	Description
E	Day of week. Use one through three letters for the short day, or four for the full name, or five for the narrow name.
e	Local day of week. Same as E except adds a numeric value that will depend on the local starting day of the week, using one or two letters.

Symbol	Description
a	AM or PM
h	Hour [1-12].
H	Hour [0-23].
K	Hour [0-11].
k	Hour [1-24].
m	Use one or two for zero places padding.
s	Use one or two for zero places padding.
S	Fractional second, rounds to the count of letters.
A	Milliseconds in day.

Symbol	Description
z	Use one to three letters for the short timezone or four for the full name.
Z	Use one to three letters for RFC 822, four letters for GMT format.
v	Use one letter for short wall (generic) time, four for long wall time.
V	Same as z, except that timezone abbreviations shoul