When designing the business logic of your application, you can use the following conversion functions:

Convert to Text

Name

Description

BooleanToText(Boolean)

Converts a Boolean value to a Text value.

IntegerToText(Integer)

Converts an Integer value to a Text value.

LongIntegerToText(Long Integer)

Converts a Long Integer value to a Text value.

DecimalToText(Decimal)

Converts a number to a text value.

DateTimeToText(DateTime)

Converts a date time value to a text value.

DateToText(Date)

Converts a date to a text value.

TimeToText(Text)

Converts a time to a text value.

IdentifierToText(Text Identifier)

Converts a Text Identifier value to a Text value.

Convert to Integer

Name

Description

BooleanToInteger(Boolean)

Converts a Boolean value to an Integer value.

LongIntegerToIntegerValidate(Long Integer)

Returns True if a Long Integer can be converted to an Integer value.

LongIntegerToInteger(Long Integer)

Converts a Long Integer to an Integer value.

DecimalToIntegerValidate(Decimal)

Returns True if a number can be converted to an Integer value.

DecimalToInteger(Decimal)

Converts a Decimal to an Integer value.

TextToIntegerValidate(Text)

Returns True if a Text can be converted to an Integer value.

TextToInteger(Text)

Converts a Text value to an Integer value.

IdentifierToInteger(Integer Identifier)

Converts an Integer Identifier value to an Integer value.

Convert to Long Integer

Name

Description

DecimalToLongIntegerValidate(Decimal)

Returns True if a Decimal can be converted to a Long Integer value.

DecimalToLongInteger(Decimal)

Converts a Decimal to a Long Integer value.

TextToLongIntegerValidate(Text)

Returns True if a Text can be converted to a Long Integer value.

TextToLongInteger(Text)

Converts a Text to a Long Integer value.

IdentifierToLongInteger(Identifier)

Converts an Identifier to a Long Integer value.

Convert to Decimal

Name

Description

IntegerToDecimal(Integer)

Converts an Integer value to a Decimal value.

TextToDecimalValidate(Text)

Returns True if a Text can be converted to a Decimal value.

TextToDecimal(Text)

Converts a Text value to a Decimal value.

Convert to Boolean

Name

Description

IntegerToBoolean(Integer)

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

DecimalToBoolean(Decimal)

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

Convert to Date Time

Name

Description

DateToDateTime(Date)

Converts a date to a date time value, adding the time component.

TextToDateTimeValidate(Text)

Returns True if a Text value can be converted to a date time value.

TextToDateTime(Text)

Converts a text to a date time value.

Convert to Date

Name

Description

DateTimeToDate(DateTime)

Converts a date time to a date value, dropping the time component.

TextToDateValidate(Text) Returns True if a Text can be converted to a date value.

TextToDate(Text)

Converts a text to a date value.

Convert to Time

Name

Description

DateTimeToTime(DateTime)

Converts a date time to a time value, dropping the date component.

TextToTimeValidate(Text)

Returns True if a Text value can be converted to a Time value.

TextToTime(Text)

Converts a text to a time value.

Convert to Identifier

Name

Description

IntegerToIdentifier(Integer)

Converts an Integer value to an Integer Identifier.

LongIntegerToIdentifier(Long Integer)

Converts a Long Integer value to an Identifier.

TextToIdentifier(Text)

Converts a Text value to a Text Identifier.

Convert to Object

Name

Description

ToObject(Expression of any data type)

Converts an expression to an Object value.

Default Value Functions

Name

Description

NullBinary()

Returns an empty binary data value.

NullDate()

Returns the default date value.

NullIdentifier()

Returns an Identifier pointing to no record. Valid for Integer and Long Integer Identifiers.

NullTextIdentifier()

Returns a Text Identifier pointing to no record.

NullObject()

Returns an empty Object value.

See Also

Available Data Types