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

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 31, 2018, at 11:47.