×

Have You Seen Workflow Lately? Click here to check out all the new features in the latest version.

Supercharge your GE solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Learn more about the Proficy 2024 releases, by signing up for one of our upcoming events.

Home
Orientation
Expression Editor
Expression Editor
Expressions combine or manipulate one or more pieces of data into a new piece of data using mathematical or boolean logic, as well as a set of built-in functions; therefore, they must follow the standard algebraic rules for order of operations.
Conversion Functions in Expressions
Conversion functions convert expressions of one data type to another data type when data type conversions are not automatically performed by SQL Server.

Workflow Products Documentation

Orientation
- Workflow Overview
- User Interface
- Resources
- Search for Resources
- Expression Editor
  - Expression Editor
    Expressions combine or manipulate one or more pieces of data into a new piece of data using mathematical or boolean logic, as well as a set of built-in functions; therefore, they must follow the standard algebraic rules for order of operations.
    - Expression Functions
      A function performs a calculation between values in order to produce another value. When functions are used in an expression, they aid in the expression's evaluation.
    - Math Functions in Expressions
      Math functions are used for mathematical calculations in an expression.
    - Conversion Functions in Expressions
      Conversion functions convert expressions of one data type to another data type when data type conversions are not automatically performed by SQL Server.
    - Logical Functions in Expressions
      Logical functions perform an operation or comparison on objects and expressions.
    - Text Functions in Expressions
      Text functions perform an operation on a string input value and return a string or numeric value.
    - Date Functions in Expressions
      Date functions perform an operation on a date and time input value and return a string, numeric, or date and time value.
    - Expression Operators
      An operator performs an operation in an expression on one or more elements that hold value.
    - Expression Variables
      Variables are previously configured components in Workflow models that can be included in an expression for evaluation.
    - String, Numeric, and Boolean Literals in Expressions
      A literal is a textual representation of a particular value in an expression.

Conversion Functions in Expressions

Conversion functions convert expressions of one data type to another data type when data type conversions are not automatically performed by SQL Server.

This function uses a date, time, or numeric value and returns a formatted string representing that value according to a specified style string.

You can find these formats at the following Microsoft websites:

Predefined numeric formats: http://msdn.microsoft.com/en-us/library/y006s0cz.aspx

User-defined numeric formats: http://msdn.microsoft.com/en-us/library/4fb56f4y.aspx

Predefined date/time formats: http://msdn.microsoft.com/en-us/library/az4se3k1.aspx

User-defined date/time formats: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

Conversion

The following information describes the functions available for building expressions.

Function	Syntax	Description	Example
Trunc	TRUNC(number)	Calculates the integral part of a number.	TRUNC(3.67) = 3
ToDouble	ToDouble(number)	Converts a number or string to a double.	"4.5" = 4.5
ToDecimal	ToDecimal(number)	Converts a number or string to a decimal.	"4.5" = 4.5
ToString	ToString(object)	Converts a value to a string. A null value becomes "NULL."	ToString(4.5) = "4.5"
Format	FORMAT(number, style)	Converts a number or date to a string formatted according to instructions contained in a format string expression. Returns a string value.	FORMAT(4.5, "E") = "4.500000E+000"