Data Conversion
| 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. Note that, when using the date format defined in the environment configuration, the function will only accept the separator character defined in that date format. For example, if the environment date format is set to 'DD-MM-YYYY', you cannot use '/' or '.' as separators in 't'. |
| 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. Note that, when using the date format defined in the environment configuration, the function will only accept the separator character defined in that date format. For example, if the environment date format is set to 'DD-MM-YYYY', you cannot use '/' or '.' as separators in 't'. |
| 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 "." (period). If 't' is outside the boundaries of Decimal values, the function returns the Decimal default value. However, if you use TextToDecimal in an Aggregate and 't' is outside the boundaries of Decimal values, the function throws an exception. To check if the conversion is possible, 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 Integer values, the function returns the Integer default value. However, if you use TextToInteger in an Aggregate and 't' is outside the boundaries of Integer values, the function throws an exception. To check if the conversion is possible, use the TextToIntegerValidate function. |
| TextToLongInteger(Text) | Converts Text 't' to a Long Integer value. If 't' is outside the boundaries of Long Integer values, the function returns the Long Integer default value. However, if you use TextToLongInteger in an Aggregate and 't' is outside the boundaries of Long Integer values, the function throws an exception. To check if the conversion is possible, 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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
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.
Output
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.
Output
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.
Output
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
Output
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
Output
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
Output
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
Output
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 "." (period).
If 't' is outside the boundaries of Decimal values, the function returns the Decimal default value. However, if you use TextToDecimal in an Aggregate and 't' is outside the boundaries of Decimal values, the function throws an exception. To check if the conversion is possible, 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
Output
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
Output
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 Integer values, the function returns the Integer default value. However, if you use TextToInteger in an Aggregate and 't' is outside the boundaries of Integer values, the function throws an exception. To check if the conversion is possible, 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
Output
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 Long Integer values, the function returns the Long Integer default value. However, if you use TextToLongInteger in an Aggregate and 't' is outside the boundaries of Long Integer values, the function throws an exception. To check if the conversion is possible, 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
Output
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
Output
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
Output
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
Output
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
Output
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
Output
Type: Object