Expressions

Expressions allow you to operate on number, texts, lists and other elements available on your K2 views and forms. This document describes the sections that are supported and which of the expressions in those sections are supported. What the actual expressions do can be found in the K2 documentation.

Note

At the moment of writing this document, we only support expressions that are transferred to a control using a transfer data. Setting an expression directly on a control is not yet supported.

Conversion

• To Boolean

• To Date

• To Date and Time

• To DateTime

• To Decimal

• To Number

• To Text

• To Time

• To Time Duration From Milliseconds

Date and Time

• Add Days

• Add Hours

• Add Minutes

• Add Seconds

• Date/Time Difference

• Day

• Day Difference

• End of Month

• End of Quarter

• End of Week

• End of Year

• Format Date and Time

• Month

• Now

• Start of Month

• Start of Quarter

• Start of Week

• Start of Year

• Subtract Days

• Subtract Hours

• Subtract Minutes

• Subtract Seconds

• Today

• Tomorrow

• Week Number

• Weekday

• Year

• Yesterday

List Aggregators

• List Average

• List Count

• List Maximum

• List Minimum

• List Sum

Logical

• And

• Equals

• Greater Than

• Greater Than Equals

• If

• Less Than

• Less Than Equals

• Not

• Not Equals

• Or

• Xor

• False

• True

Mathematical

• Absolute

• Format Number

• Power

• Random

• Root

• Round

• Round Down

• Round Up

• Square

• Square Root

Operators

• Divide

• Minus

• Modulus

• Multiply

• Plus

• Opening Parenthesis

• Closing Parenthesis

Regular Expressions

• Matches

• Not Matches

Text

• Concatenate

• Contains

• Ends With

• Find

• Html Decode

• Html Encode

• Hyperlink

• Insert

• Is Blank

• Is Not Blank

• Join

• Left

• Length

• Mid

• Pad Left

• Pad Right

• Proper

• Replace

• Right

• Starts With

• To Lower

• To Upper

• Trim

• Url Decode

• Url Encode

• Xml Decode

• Xml Encode

• (Empty String)

Value Aggregators

• Average

• Maximum

• Minimum

• Sum