Jump to: navigation, search

Functions

The Field Codes include the following functions:

String Functions

The Field Codes include the following string functions:

[+] Find


[+] Left


[+] Length


[+] Mid


[+] Replace


[+] Right


[+] To Lower


[+] ToUpper


[+] Trim


[+] TrimLeft


[+] TrimRight


[+] FullName


Date and Time Functions

The Field Codes include the following date/time functions:

[+] Date


[+] Day


[+] Hour12


[+] Hour24


[+] IsAm


[+] IsPm


[+] Minute


[+] Month


[+] MonthName


[+] MonthNameShort


[+] Second


[+] Time


[+] TimeGMT


[+] ToTimeZoneDate


[+] Weekday


[+] WeekdayName


[+] WeekdayNameShort


[+] Year


[+] YearShort

Type Conversion

The Field Codes use the following type conversions:

Bool

[+] Bool


Num

[+] Num


Text

[+] Text


[+] Number Formatting


[+] Duration Formatting


[+] Currency Formatting


[+] Percentage Formatting


[+] Date/Time Formatting


[+] Boolean Formatting


[+] String Formatting


Mathematical Functions

The Field Codes include the following mathematical functions:

Abs

[+] Abs


Ceil

[+] Ceil


Floor

[+] Floor

Miscellaneous Functions

The Field Codes include the following miscellaneous functions:

If

[+] If


IsBoolean

[+] IsBoolean


IsDateTime

[+] IsDateTime


IsNumber

[+] IsNumber


IsString

[+] IsString


Type

[+] Type


This page was last edited on August 31, 2018, at 19:47.
Comments or questions about this documentation? Contact us for support!