|
Arithmetic and Mathematical Functions
| |||
|
ABS
|
BRND
|
DIM
|
EXP
|
|
LAVG
|
LMAX
|
LMIN
|
LOG
|
|
LOG10
|
MOD
|
RANDOM
|
ROUND
|
|
SIGN
|
SQRT
|
|
|
|
|
|
|
|
|
Conversion Functions
| |||
|
AINT
|
ANINT
|
CHAR
|
CTXT
|
|
DWRD
|
FLOAT
|
HTML
|
ICHAR
|
|
IHASH
|
INT
|
NINT
|
SOUNDEX
|
|
|
|
|
|
|
Date and Time Functions
| |||
|
ADDDAY
|
ADDFRC
|
ADDHR
|
ADDMIN
|
|
ADDMON
|
ADDSEC
|
ADDYR
|
DATETIME
|
|
DEXTRACT
|
IDAY
|
IDWK
|
IFRC
|
|
IHR
|
IMIN
|
IMON
|
ISEC
|
|
IYR
|
JDATE
|
RDATE
|
RTIME
|
|
TDWK
|
TEXTRACT
|
TMON
|
|
|
|
|
|
|
|
Financial Functions
| |||
|
FV1
|
FV2
|
PMT1
|
PMT2
|
|
PV1
|
PV2
|
RATE1
|
RATE2
|
|
RATE3
|
TERM1
|
TERM2
|
TERM3
|
|
|
|
|
|
|
Keyboard and Operating System Functions
| |||
|
ENVVAL
|
CVAL
|
CHKCUR
|
CHKKEY
|
|
CHKFILE
|
CHKVAR
|
DLFREE
|
DLLOAD
|
|
FILENAME
|
FINDFILE
|
IFWINDOW
|
ISTAT
|
|
GETKEY
|
LASTKEY
|
|
|
|
Logical Functions
| |||
|
IFEQ
|
IFEXISTS
|
IFGT
|
IFLT
|
|
IFNULL
|
|
|
|
|
|
|
|
|
|
String Manipulation Functions
| |||
|
CTR
|
DNW
|
DWE
|
FORMAT
|
|
ICAP
|
ICAP1
|
ICAP2
|
IDIM
|
|
IDOY
|
ILY
|
ISALPHA
|
ISDIGIT
|
|
ISLOWER
|
ISSPACE
|
ISTR
|
ISUPPER
|
|
ITEMCNT
|
IWOY
|
LJS
|
LTRIM
|
|
LUC
|
RJS
|
RTRIM
|
SFIL
|
|
SGET
|
SKEEP
|
SKEEPI
|
SLEN
|
|
SLOC
|
SLOCP
|
SMOVE
|
SPUT
|
|
SRPL
|
SSTRIP
|
SSTRIPI
|
SSUB
|
|
STRIM
|
TRIM
|
ULC
|
|
|
|
|
|
|
|
Trigonometric Functions
| |||
|
ACOS
|
ASIN
|
ATAN
|
ATAN2
|
|
COS
|
COSH
|
SIN
|
SINH
|
|
TAN
|
TANH
|
|
|
|
|
|
|
|
|
Custom Functions
| |||
|
UDF
|
WINUDF
|
|
|