×

Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2024 releases!

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.
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.
Time Span Functions in Expressions
Time span values represent an interval of time. Time span functions perform operations on these values.

Workflow IPI
Get Started
Tutorials
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.
      - Time Zone Abbreviations for Date and Time Functions
        Workflow recognizes that company operations may exist across time zones; therefore, you can build logic into your workflows that allows them to recognize multiple time zones and ensures that production is not affected.
      - Time Span Functions in Expressions
        Time span values represent an interval of time. Time span functions perform operations on these values.
    - 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.
Configure Your Environment
Security
Resource Information and Configuration
Data Administration
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

Time Span Functions in Expressions

Time span values represent an interval of time. Time span functions perform operations on these values.

The following information describes the functions available for building expressions.

Tip:

Any information within square brackets [ ] is optional.

TimeOfDay

Description: Gets the time components of a DateTime value. Only the time part of the date is associated with the time zone.

Format: TimeOfDay(date)

Parameters	Required?	Data Type	Description
date	Yes	DateTime	Date/time to isolate the time from.

Time

Description: Creates a time value based on time components. The return value is a time span value.

Format: Time(days, hours, minutes, seconds, milliseconds)

Parameters	Required?	Data Type	Description
days	Yes	Numeric	Number of days to include in the time value.
hours	Yes	Numeric	Number of hours to include in the time value.
minutes	Yes	Numeric	Number of minutes to include in the time value.
seconds	Yes	Numeric	Number of seconds to include in the time value.
milliseconds	Yes	Numeric	Number of milliseconds to include in the time value.

FromDays

Description: Creates a TimeSpan value by specifying the number of days in a time span.

Format: FromDays(days)

Parameters	Required?	Data Type	Description
days	Yes	Numeric	Number of days.

FromHours

Description: Creates a TimeSpan value by specifying the number of hours in a time span.

Format: FromHours(hours)

Parameters	Required?	Data Type	Description
hours	Yes	Numeric	Number of hours.

FromMinutes

Description: Creates a TimeSpan value by specifying the number of minutes in a time span.

Format: FromMinutes(minutes)

Parameters	Required?	Data Type	Description
minutes	Yes	Numeric	Number of minutes.

FromSeconds

Description: Creates a TimeSpan value by specifying the number of seconds in a time span.

Format: FromSeconds(seconds)

Parameters	Required?	Data Type	Description
seconds	Yes	Numeric	Number of seconds.

FromMilliseconds

Description: Creates a TimeSpan value by specifying the number of milliseconds in a time span.

Format: FromMilliseconds(milliseconds)

Parameters	Required?	Data Type	Description
milliseconds	Yes	Numeric	Number of milliseconds.

Days

Description: Returns the days component of a time span value.

Format: Days(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Time to extract the component from.

Hours

Description: Returns the hours component of a time span value.

Format: Hours(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Time to extract the component from.

Minutes

Description: Returns the minutes component of a time span value.

Format: Minutes(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Time to extract the component from.

Seconds

Description: Returns the seconds component of a time span value.

Format: Seconds(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Time to extract the component from.

Milliseconds

Description: Returns the milliseconds component of a time span value.

Format: Milliseconds(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Time to extract the component from.

TotalDays

Description: Converts a TimeSpan value to a number of days. The return type is a double.

Format: TotalDays(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Total time span value expressed as a number of days.

TotalHours

Description: Converts a TimeSpan value to a number of hours. The return type is a double.

Format: TotalHours(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Total time span value expressed as a number of hours.

TotalMinutes

Description: Converts a TimeSpan value to a number of minutes. The return type is a double.

Format: TotalMinutes(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Total time span value expressed as a number of minutes.

TotalSeconds

Description: Converts a TimeSpan value to a number of seconds. The return type is a double.

Format: TotalSeconds(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Total time span value expressed as a number of seconds.

TotalMilliseconds

Description: Converts a TimeSpan value to a number of milliseconds. The return type is a double.

Format: TotalMilliseconds(timespan)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Total time span value expressed as a number of milliseconds.

Duration

Description: Returns the absolute value of a time span.

Format: Duration(timespan)

Example

Time(0,-5,0,0,0) represents -5 hours. Using Duration, you get a time span that represents +5 hours:

Duration(Time(0,-5,0,0,0)) = Time(0,5,0,0,0)

Duration(FromHours(-5)) = FromHours(5)

Parameters	Required?	Data Type	Description
timespan	Yes	TimeSpan	Time span value to get the absolute value of.