Functions listed Alphbetically

• ABS( )
• ACOS( )
• Addition: + (addition)
• ADDYEARS( )
• AGE( )
• ALEN( )
• ALLTRIM( )
• ANGLE( )
• APACK( )
• APPEND (to a Roster)
• APPENDTOFILE( )
• ASIN( )
• ATAN( )
• AT( )

• BLANK

• CDOW( )
• CLEAN ROSTER
• CLONE ROSTER
• CODE( )
• Comparative Functions: >, <, ==, etc.
• COMPRESS ROSTER
• COPYFILE( )
• COS( )
• COUNT( )
• COUNTROSTER( )
• CREATE CALENDAR( )

• DATE( )
• DATE2DAY( )
• DATE2TEXT( )
• DATE2WK( )
• DATEFORMAT( )
• DECODE( )
• DELETEFILE( )
• DELETE FROM
• DIFFAGE( )
• Division: / (division)
• DOW( )

• ENDFOR, used in FOR ... ENDFOR
• ENDWHILE, used in WHILE .. ENDWHILE
• Exponential: see Power of

• FILE( )
• FINDGAPS IN CALENDAR
• FIXDAY( )
• FIXMONTH( )
• FIXYEAR( )
• FOR ... ENDFOR

• GETSUBDATE( )
• GOMONTH( )

• IIF( )
• IN( )
• INLIST( )
• INSELECTION( )
• INT( )
• ISCOMPLETE( )
• ISTIMECOMPLETE( )
• ISVAREMPTY( )

• LANGUAGE
• LEN( )
• LOG( )
• Logical Functions: ||, &&, !, NOT
• LTRIM( )
• LOWER
  

• MARK CALENDAR
• MAX( )
• MAXINSELECTION( )
• MIN( )
• MININSELECTION( )
• MOD( )
• Multiplication: * (multiplication)

• Not: !(NOT)

• PADL( )
• Power of: ^ (exponentiation)

• RAND( )
• RAT( )
• READFILE( )
• RECCOUNT( )
• RECORDAUDIO( )
• REPEAT ... UNTIL
• ROUND( )

• SELECTEDINSELECTION( )
• SETAUDIO
• SETRECORDAUDIO
• SET HEADER
• SIN( )
• SORT
• STR( )
• STRCMP( )
• SUBSTR( )
• Subtraction: - (subtraction)
• SWITCH( )
• SYMBOL( )

• TAN( )
• TEXT2DATE( )
• TIME( )
• TIME2TEXT( )
• TITLECASE
• TOTALINSELECTION( )

• UNTIL( ) used in REPEAT ... UNTIL
• UPDATE
• UPDATELOGIN( )
• UPPER

• VAL( )
• VAREXIST( )
• VARTYPE( )

• WEEKLYWAGE( )
• WHILE … ENDWHILE

• XFER

Functions by Type

Array functions
Date functions
File functions
Logical functions
Math functions
Picklist functions
Programming functions
Time functions
Select All That Apply functions
String functions
Roster functions
Variable manipulation functions


Array functions Top

ALEN
APACK
BLANK
COUNT


Audio functions Top

RECORDAUDIO( )
SETAUDIO
SETRECORDAUDIO

Date functions Top

ADDYEARS
AGE
CDOW
CREATE CALENDAR
DATE
DATE2DAY
DATE2TEXT
DATE2WK
DATEFORMAT
DIFFAGE
DOW
FINDGAPS IN CALENDAR
FIXDAY
FIXMONTH
FIXYEAR
GETSUBDATE
GOMONTH
ISCOMPLETE
MARK CALENDAR
TEXT2DATE


File functions Top

APPENDTOFILE
COPYFILE
DELETEFILE
FILE
READFILE


Logical functions Top

> < <= >= ==
IIF
||
&&
!
NOT


Math functions Top

+ - * / ^ %
See individual math symbols in left column.
ABS
ACOS
ANGLE
ASIN
ATAN
CODE
COS
INT
LOG
MAX
MIN
MOD
RAND
ROUND
SIN
TAN
VAL
WEEKLYWAGE


Picklist functions Top

CODE
DECODE


Programming functions Top

FOR…ENDFOR
IIF
ISVAREMPTY
LANGUAGE
REPEAT…UNTIL
SET HEADER TO
SWITCH
SYMBOL
VAREXIST
VARTYPE
WHILE…ENDWHILE
WRITEGLOBAL


Select All That Apply functions Top

INSELECTION
MAXINSELECTION
MININSELECTION
SELECTEDINSELECTION
TOTALINSELECTION


String functions Top

+
ALLTRIM
AT
CDOW
DATE2TEXT
DECODE
IN
LEN
LOWER
LTRIM
PADL
RAT
STR
STRCMP
SUBSTR
TEXT2DATE
TIME2TEXT
TITLECASE
UPPER
VAL


Roster functions Top

APPEND
CLEAN ROSTER
CLONE ROSTER
COMPRESS ROSTER
COUNTROSTER
DELETE FROM
RECCOUNT
SORT
UPDATE
XFER


Time functions Top

ISTIMECOMPLETE
TIME
TIME2TEXT


Variable Manipulation functions Top

BLANK
INLIST
ISVAREMPTY
SWITCH
SYMBOL
VAREXIST
VARTYPE