Data Conversion

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

See Also

• Available Data Types
• Expressions