Data Conversion Built-in Functions

Name Description
BooleanToInteger(​Boolean) Converts Boolean 'b' to an Integer value, either 1 if 'b' is True or 0 if 'b' is False.
BooleanToText(​Boolean) Converts Boolean 'b' to a Text value, either "True" or "False".
DateTimeToDate(​DateTime) Converts Date Time 'dt' to a Date value dropping the Time component.
DateTimeToText(​DateTime) Converts Date Time 'dt' to a Text value in the format specified in the environment configuration (by default, "yyyy-MM-dd HH:mm:ss").
DateTimeToTime(​DateTime) Converts Date Time 'dt' to a Time value dropping the Date component.
DateToDateTime(​Date) Converts Date 'd' to a Date Time value, adding the Time component (#00:00:00#).
DateToText(​Date) Converts Date 'd' to a Text value in the format specified in the environment configuration (by default, "yyyy-MM-dd").
DecimalToBoolean(​Decimal) Converts Decimal 'd' to a Boolean value. Decimal value of 0.0 is False. Any other value is True.
DecimalToInteger(​Decimal) Converts Decimal 'd' to an Integer value.
In client-side and server-side logic, the function rounds the input using the round half to even method. In Aggregate expressions the function truncates to the integer part of the input.
To check if the conversion is possible you can use the DecimalToIntegerValidate function.
DecimalToIntegerValidate(​Decimal) Returns true if Decimal 'd' can be converted to an Integer value.
DecimalToLongInteger(​Decimal) Converts Decimal 'd' to a Long Integer value.
In client-side and server-side logic, the function rounds the input using the round half to even method. In Aggregate expressions the function truncates to the integer part of the input.
To check if the conversion is possible you can use the DecimalToLongIntegerValidate function.
DecimalToLongIntegerValidate(​Decimal) Returns true if Decimal 'd' can be converted to a Long Integer value.
DecimalToText(​Decimal) Converts Decimal 'd' to a Text value.
LongIntegerToInteger(​LongInteger) Converts Long Integer 'l' to an Integer value. If 'l' is outside the boundaries of the Integer values, the function will return the Integer default value. To check if the conversion is possible you can use the LongIntegerToIntegerValidate function.
LongIntegerToIntegerValidate(​LongInteger) Returns true if Long Integer 'l' can be converted to an Integer value.
LongIntegerToIdentifier(​LongInteger) Converts Long Integer 'l' to a Long Integer Identifier.
LongIntegerToText(​LongInteger) Converts Long Integer 'l' to a Text value.
IdentifierToInteger(​EntityReference) Converts Identifier 'Id' to an Integer value.
IdentifierToLongInteger(​EntityReferenceLongInteger) Converts Identifier 'Id' to a Long Integer value.
IdentifierToText(​EntityReferenceText) Converts Identifier 'Id' to a Text value.
IntegerToBoolean(​Integer) Converts Integer 'i' to a Boolean value. Boolean value of 0 is False. Any other value is True.
IntegerToDecimal(​Integer) Converts Integer 'i' to a Decimal value.
IntegerToIdentifier(​Integer) Converts Integer 'i' to an Integer Identifier.
IntegerToText(​Integer) Converts Integer 'i' to a Text value.
NullDate() Returns a null Date value.
NullIdentifier() Returns a null Identifier valid for Integer and Long Integer Identifiers.
NullObject() Returns a null Object value.
NullBinary() Returns a null Binary Data value.
NullTextIdentifier() Returns a null Text Identifier.
TextToDate(​Text) Converts Text 't' to a Date value.
If 't' can't be converted to a valid Date value, the function will return the Date default value. To check if the conversion is possible you can use the TextToDateValidate function.
You should check the limits of the Date data type. You should also ensure that the date you type in the argument complies with the default date format (yyyy-mm-dd, yyyy/mm/dd, and yyyy.mm.dd) or the server’s environment configuration.
TextToDateTime(​Text) Converts Text 't' to a Date Time value.
If 't' can't be converted to a valid Date Time value, the function will return a Date Time default value. To check if the conversion is possible you can use the TextToDateTimeValidate function.
You should check the limits of the Date Time data type. You should also ensure that the Date Time you type in the argument complies with the default Date Time format (yyyy-mm-dd hh:mm:ss, yyyy/mm/dd hh:mm:ss, and yyyy.mm.dd hh:mm:ss) or the server’s environment configuration.
TextToDateTimeValidate(​Text) Returns true if Text 't' can be converted to a Date Time value.
TextToDateValidate(​Text) Returns true if Text 't' can be converted to a Date value.
TextToDecimal(​Text) Converts Text 't' to a Decimal value. The only allowed decimal separator is the ".". If 't' is outside the boundaries of the Decimal values, the function will return the Decimal default value. To check if the conversion is possible you can use the TextToDecimalValidate function.
TextToDecimalValidate(​Text) Returns true if Text 't' can be converted to a Decimal value.
TextToIdentifier(​Text) Converts Text 't' to a Text Identifier.
TextToInteger(​Text) Converts Text 't' to an Integer value.
If 't' is outside the boundaries of the Integer values the function will return an Integer default value. To check if the conversion is possible you can use the TextToIntegerValidate function.
TextToLongInteger(​Text) Converts Text 't' to a Long Integer value.
If 't' is outside the boundaries of the Long Integer values the function will return a Long Integer default value. To check if the conversion is possible you can use the TextToLongIntegerValidate function.
TextToIntegerValidate(​Text) Returns true if Text 't' can be converted to an Integer value.
TextToLongIntegerValidate(​Text) Returns true if Text 't' can be converted to a Long Integer value.
TextToTime(​Text) Converts Text 't' to a Time value.
If 't' can't be converted to a valid Time value, the function will return the Time default value. To check if the conversion is possible you can use the TextToTimeValidate function.
You should check the limits of the Time data type. You should also ensure that the Time you type in the argument complies with the Time format (hh:mm:ss).
TextToTimeValidate(​Text) Returns true if Text 't' can be converted to a Time value.
TimeToText(​Time) Converts Time 't' to a Text value in the format "HH:mm:ss".
ToObject(​Generic) Converts expression 'exp' to an Object value.

BooleanToInteger

Converts Boolean 'b' to an Integer value, either 1 if 'b' is True or 0 if 'b' is False.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

b
Type: Boolean. Mandatory.
The value to be converted

Type: Integer

Examples

``````BooleanToInteger(True) = 1
BooleanToInteger(False) = 0
``````

BooleanToText

Converts Boolean 'b' to a Text value, either "True" or "False".

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

b
Type: Boolean. Mandatory.
The value to be converted

Type: Text

Examples

``````BooleanToText(True) = "True"
BooleanToText(False) = "False"
``````

DateTimeToDate

Converts Date Time 'dt' to a Date value dropping the Time component.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

dt
Type: DateTime. Mandatory.
The value to be converted

Type: Date

Examples

``````DateTimeToDate(#2013-11-30 22:20:30#) = #2013-11-30#
``````

DateTimeToText

Converts Date Time 'dt' to a Text value in the format specified in the environment configuration (by default, "yyyy-MM-dd HH:mm:ss").

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

dt
Type: DateTime. Mandatory.
The value to be converted

Type: Text

Examples

``````DateTimeToText(#2015-05-21 22:20:30#) = "2015-05-21 22:20:30"
DateTimeToText(#2015-05-21#) = "2015-05-21 00:00:00"
DateTimeToText(#22:20:30#) = "1900-01-01 22:20:30"
``````

DateTimeToTime

Converts Date Time 'dt' to a Time value dropping the Date component.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

dt
Type: DateTime. Mandatory.
The value to be converted

Type: Time

Examples

``````DateTimeToTime(#1982-05-21 22:20:30#) = #22:20:30#
``````

DateToDateTime

Converts Date 'd' to a Date Time value, adding the Time component (#00:00:00#).

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

d
Type: Date. Mandatory.
The value to be converted

Type: DateTime

Examples

``````DateToDateTime(#2001-09-14#) = #2001-09-14 00:00:00#
``````

DateToText

Converts Date 'd' to a Text value in the format specified in the environment configuration (by default, "yyyy-MM-dd").

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

d
Type: Date. Mandatory.
The value to be converted

Type: Text

Examples

``````DateToText(#2010-05-17#) = "2010-05-17"
DateToText(#2010-05-17 22:30:32#) = "2010-05-17"
``````

DecimalToBoolean

Converts Decimal 'd' to a Boolean value. Decimal value of 0.0 is False. Any other value is True.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

d
Type: Decimal. Mandatory.
The value to be converted

Type: Boolean

Examples

``````DecimalToBoolean(0.0) = False
DecimalToBoolean(0.05) = True
``````

DecimalToInteger

Converts Decimal 'd' to an Integer value.
In client-side and server-side logic, the function rounds the input using the round half to even method. In Aggregate expressions the function truncates to the integer part of the input.
To check if the conversion is possible you can use the DecimalToIntegerValidate function.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

d
Type: Decimal. Mandatory.
The value to be converted

Type: Integer

Examples

``````When used in client-side and server-side logic:
DecimalToInteger(134.2) = 134
DecimalToInteger(134.5) = 134
DecimalToInteger(133.5) = 134
DecimalToInteger(134.7) = 135
DecimalToInteger(134) = 134
DecimalToInteger(12345678999.9) = 0

When used in Aggregates:
DecimalToInteger(134.2) = 134
DecimalToInteger(134.5) = 134
DecimalToInteger(133.5) = 133
DecimalToInteger(134.7) = 134
DecimalToInteger(134) = 134
DecimalToInteger(12345678999.9) = Arithmetic Overflow Error
``````

DecimalToIntegerValidate

Returns true if Decimal 'd' can be converted to an Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

d
Type: Decimal. Mandatory.
The value to be converted

Type: Boolean

Examples

``````DecimalToIntegerValidate(134.2) = True
DecimalToIntegerValidate(134.5) = True
DecimalToIntegerValidate(133.5) = True
DecimalToIntegerValidate(134.7) = True
DecimalToIntegerValidate(134) = True
DecimalToIntegerValidate(12345678999.9) = False
``````

DecimalToLongInteger

Converts Decimal 'd' to a Long Integer value.
In client-side and server-side logic, the function rounds the input using the round half to even method. In Aggregate expressions the function truncates to the integer part of the input.
To check if the conversion is possible you can use the DecimalToLongIntegerValidate function.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

d
Type: Decimal. Mandatory.
The value to be converted

Output

Type: LongInteger

Examples

``````When used in client-side and server-side logic:
DecimalToLongInteger(134.2) = 134
DecimalToLongInteger(134.5) = 134
DecimalToLongInteger(133.5) = 134
DecimalToLongInteger(134.7) = 135
DecimalToLongInteger(134) = 134
DecimalToLongInteger(157898999999988844444.2) = 0

When used in Aggregates:
DecimalToLongInteger(134.2) = 134
DecimalToLongInteger(134.5) = 134
DecimalToLongInteger(133.5) = 133
DecimalToLongInteger(134.7) = 134
DecimalToLongInteger(134) = 134
DecimalToLongInteger(157898999999988844444.2) = Arithmetic Overflow Error
``````

DecimalToLongIntegerValidate

Returns true if Decimal 'd' can be converted to a Long Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

d
Type: Decimal. Mandatory.
The value to be converted

Type: Boolean

Examples

``````DecimalToLongIntegerValidate(134.2) = True
DecimalToLongIntegerValidate(134.5) = True
DecimalToLongIntegerValidate(133.5) = True
DecimalToLongIntegerValidate(134.7) = True
DecimalToLongIntegerValidate(134) = True
DecimalToLongIntegerValidate(157898999999988844444.2) = False
``````

DecimalToText

Converts Decimal 'd' to a Text value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

d
Type: Decimal. Mandatory.
The value to be converted

Type: Text

Examples

``````DecimalToText(200.482) = "200.482"
DecimalToText(200) = "200"
``````

LongIntegerToInteger

Converts Long Integer 'l' to an Integer value. If 'l' is outside the boundaries of the Integer values, the function will return the Integer default value. To check if the conversion is possible you can use the LongIntegerToIntegerValidate function.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

l
Type: LongInteger. Mandatory.
The value to be converted

Type: Integer

Examples

``````LongIntegerToInteger(3000) = 3000
LongIntegerToInteger(5645245584135987412) = 0
``````

LongIntegerToIntegerValidate

Returns true if Long Integer 'l' can be converted to an Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

l
Type: LongInteger. Mandatory.
The value to be converted

Type: Boolean

Examples

``````LongIntegerToIntegerValidate(3000) = True
LongIntegerToIntegerValidate(5645245584135987412) = False
``````

LongIntegerToIdentifier

Converts Long Integer 'l' to a Long Integer Identifier.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

l
Type: LongInteger. Mandatory.
The value to be converted

Output

Type: EntityReferenceLongInteger

Examples

``````LongIntegerToIdentifier(5090493034304) = 5090493034304
``````

LongIntegerToText

Converts Long Integer 'l' to a Text value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

l
Type: LongInteger. Mandatory.
The value to be converted

Type: Text

Examples

``````LongIntegerToText(5092039102) = "5092039102"
``````

IdentifierToInteger

Converts Identifier 'Id' to an Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

id
Type: EntityReference. Mandatory.
The value to be converted

Type: Integer

Examples

``````IdentifierToInteger(GetUserId()) = 504 (the result may be different in your module)
``````

IdentifierToLongInteger

Converts Identifier 'Id' to a Long Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

id
Type: EntityReferenceLongInteger. Mandatory.
The value to be converted

Output

Type: LongInteger

Examples

``````IdentifierToLongInteger(GetUserId()) = 30 (the result may be different in your module)
``````

IdentifierToText

Converts Identifier 'Id' to a Text value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

id
Type: EntityReferenceText. Mandatory.
The value to be converted

Type: Text

Examples

``````IdentifierToText(GetUserId()) = "30" (the result may be different in your module)
``````

IntegerToBoolean

Converts Integer 'i' to a Boolean value. Boolean value of 0 is False. Any other value is True.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

i
Type: Integer. Mandatory.
The value to be converted

Type: Boolean

Examples

``````IntegerToBoolean(10) = True
IntegerToBoolean(-10) = True
IntegerToBoolean(0) = False
``````

IntegerToDecimal

Converts Integer 'i' to a Decimal value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

i
Type: Integer. Mandatory.
The value to be converted

Type: Decimal

Examples

``````IntegerToDecimal(200) = 200
``````

IntegerToIdentifier

Converts Integer 'i' to an Integer Identifier.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

i
Type: Integer. Mandatory.
The value to be converted

Output

Type: EntityReference

Examples

``````IntegerToIdentifier(5) = 5
``````

IntegerToText

Converts Integer 'i' to a Text value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

i
Type: Integer. Mandatory.
The value to be converted

Type: Text

Examples

``````IntegerToText(200) = "200"
``````

NullDate

Returns a null Date value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Type: Date

Examples

``````NullDate() = #1900-01-01#
``````

NullIdentifier

Returns a null Identifier valid for Integer and Long Integer Identifiers.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Output

Type: EntityReference

Examples

``````NullIdentifier() = 0
``````

NullObject

Returns a null Object value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Type: Object

Examples

``````ObjectVariable = NullObject()
``````

NullBinary

Returns a null Binary Data value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Type: BinaryData

Examples

``````BinaryDataVariable = NullBinary()
``````

NullTextIdentifier

Returns a null Text Identifier.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Output

Type: EntityReferenceText

Examples

``````NullTextIdentifier() = ""
``````

TextToDate

Converts Text 't' to a Date value.
If 't' can't be converted to a valid Date value, the function will return the Date default value. To check if the conversion is possible you can use the TextToDateValidate function.
You should check the limits of the Date data type. You should also ensure that the date you type in the argument complies with the default date format (yyyy-mm-dd, yyyy/mm/dd, and yyyy.mm.dd) or the server’s environment configuration.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Date

Examples

``````TextToDate("2002-01-01") = #2002-01-01#
TextToDate("2002/01/01") = #2002-01-01#
TextToDate("2002.01.01") = #2002-01-01#
TextToDate("2002-25-01") = #1900-01-01#
TextToDate("2002/02/31") = #1900-01-01#
TextToDate("10000.01.01") = #1900-01-01#
``````

TextToDateTime

Converts Text 't' to a Date Time value.
If 't' can't be converted to a valid Date Time value, the function will return a Date Time default value. To check if the conversion is possible you can use the TextToDateTimeValidate function.
You should check the limits of the Date Time data type. You should also ensure that the Date Time you type in the argument complies with the default Date Time format (yyyy-mm-dd hh:mm:ss, yyyy/mm/dd hh:mm:ss, and yyyy.mm.dd hh:mm:ss) or the server’s environment configuration.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: DateTime

Examples

``````TextToDateTime("2002-01-01 01:01:01") = #2002-01-01 01:01:01#
TextToDateTime("2002/01/01 01:01:01") = #2002-01-01 01:01:01#
TextToDateTime("2002.01.01 01:01:01") = #2002-01-01 01:01:01#
TextToDateTime("20-01-01 01:01:01") = #1900-01-01 00:00:00#
TextToDateTime("date time") = #1900-01-01 00:00:00#
TextToDateTime("2002.1.1 1-1-1") = #1900-01-01 00:00:00#
TextToDateTime("2002-01-01") = #2002-01-01 00:00:00#
TextToDateTime("01-01-01") = #1900-01-01 00:00:00#
``````

TextToDateTimeValidate

Returns true if Text 't' can be converted to a Date Time value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Boolean

Examples

``````TextToDateTimeValidate("2002-01-01 01:01:01") = True
TextToDateTimeValidate("2002/01/01 01:01:01") = True
TextToDateTimeValidate("2002.01.01 01:01:01") = True
TextToDateTimeValidate("20-01-01 01:01:01") = False
TextToDateTimeValidate("date time") = False
TextToDateTimeValidate("2002.1.1 1-1-1") = False
TextToDateTimeValidate("2002-01-01") = True
TextToDateTimeValidate("01-01-01") = False
``````

TextToDateValidate

Returns true if Text 't' can be converted to a Date value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Boolean

Examples

``````TextToDateValidate("2002-01-01") = True
TextToDateValidate("2002/01/01") = True
TextToDateValidate("2002.01.01") = True
TextToDateValidate("2002-25-01") = False
TextToDateValidate("2002/02/31") = False
TextToDateValidate("10000.01.01") = False
``````

TextToDecimal

Converts Text 't' to a Decimal value. The only allowed decimal separator is the ".". If 't' is outside the boundaries of the Decimal values, the function will return the Decimal default value. To check if the conversion is possible you can use the TextToDecimalValidate function.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Decimal

Examples

``````TextToDecimal("200") = 200
TextToDecimal("-200") = -200
TextToDecimal("200.482") = 200.482
TextToDecimal("-200.482") = -200.482
TextToDecimal("0.99999999") = 0.99999999
TextToDecimal("abc") = 0
``````

TextToDecimalValidate

Returns true if Text 't' can be converted to a Decimal value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Boolean

Examples

``````TextToDecimalValidate("200")    = True
TextToDecimalValidate("-200") = True
TextToDecimalValidate("200.482") = True
TextToDecimalValidate("-200.482") = True
TextToDecimalValidate("0.99999999") = True
TextToDecimalValidate("abc") = False
``````

TextToIdentifier

Converts Text 't' to a Text Identifier.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Output

Type: EntityReferenceText

Examples

``````TextToIdentifier("NEW") = 'NEW'
``````

TextToInteger

Converts Text 't' to an Integer value.
If 't' is outside the boundaries of the Integer values the function will return an Integer default value. To check if the conversion is possible you can use the TextToIntegerValidate function.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Integer

Examples

``````TextToInteger("200") = 200
TextToInteger("-200") = -200
TextToInteger("200.482") = 0
TextToInteger("not a number") = 0
``````

TextToLongInteger

Converts Text 't' to a Long Integer value.
If 't' is outside the boundaries of the Long Integer values the function will return a Long Integer default value. To check if the conversion is possible you can use the TextToLongIntegerValidate function.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Output

Type: LongInteger

Examples

``````TextToLongInteger("200") = 200
TextToLongInteger("-200") = -200
TextToLongInteger("56452455841359874121") = 0
TextToLongInteger("not a number") = 0
``````

TextToIntegerValidate

Returns true if Text 't' can be converted to an Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Boolean

Examples

``````TextToIntegerValidate("200") = True
TextToIntegerValidate("-200") = True
TextToIntegerValidate("200.482") = False
TextToIntegerValidate("not a number") = False
``````

TextToLongIntegerValidate

Returns true if Text 't' can be converted to a Long Integer value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Boolean

Examples

``````TextToLongIntegerValidate("200") = True
TextToLongIntegerValidate("-200") = True
TextToLongIntegerValidate("56452455841359874121") = False
TextToLongIntegerValidate("not a number") = False
``````

TextToTime

Converts Text 't' to a Time value.
If 't' can't be converted to a valid Time value, the function will return the Time default value. To check if the conversion is possible you can use the TextToTimeValidate function.
You should check the limits of the Time data type. You should also ensure that the Time you type in the argument complies with the Time format (hh:mm:ss).

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Time

Examples

``````TextToTime("12:12:12") = #12:12:12#
TextToTime("23:68:12") = #00:00:00#
TextToTime("0-0-0") = #00:00:00#
TextToTime("abc") = #00:00:00#
``````

TextToTimeValidate

Returns true if Text 't' can be converted to a Time value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

t
Type: Text. Mandatory.
The value to be converted

Type: Boolean

Examples

``````TextToTimeValidate("12:12:12") = True
TextToTimeValidate("23:68:12") = False
TextToTimeValidate("0-0-0") = False
TextToTimeValidate("abc") = False
``````

TimeToText

Converts Time 't' to a Text value in the format "HH:mm:ss".

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Can be used with attributes in aggregates.
• Local Storage: Can be used with attributes in aggregates.

Parameters

t
Type: Time. Mandatory.
The value to be converted

Type: Text

Examples

``````TimeToText(#12:30:24#) = "12:30:24"
TimeToText(#2015-07-02 12:30:34#) = "12:30:34"
``````

ToObject

Converts expression 'exp' to an Object value.

Available in:

• Server-side logic: Yes
• Client-side logic: Yes
• Database: Function is evaluated before the aggregate is executed.
• Local Storage: Function is evaluated before the aggregate is executed.

Parameters

exp
Type: Generic. Mandatory.
The element to be converted

Type: Object