Functions are listed alphabetically by type.

Date Functions:

BEGMONTH

BEGYEAR

BLANK_DATE

DATE$

DATEADD

DATENUM

DATETOUSERTZ

DAY

DOW

DOW$

ENDMONTH

ENDYEAR

ISBLANK_DATE

MKDATE

MONTH$

MONTH

TODAY

TODAY$

YEAR

 
Numeric Functions:

ABS

ASC

FIND

FIRSTNZ

IFF

INSTR

INT

ISBLANK

LEN

MOD

RNDPENNY

SIGN

USERTKPRNO

VAL

 
String Functions:

BOLD$

CALCFIRSTNAME$

CALCLASTNAME$

CALCMIDDLENAME$

CHR$

CITYSTATEZIP$

EXCLUDE$

FILECRTDATE$

FILECRTTIME$

FILEDIR$

FILEDRIVE$

FILEEXT$

FILEMODDATE$

FILEMODTIME$

FILENAME$

FILEROOTNAME$

FILETYPENAME$

FIRSTNAME$

FMT$

FROM$

FWDCLNAM$

IFF$

ISBLANK

ITALIC$

LASTNAME$

LCASE$

LEFT$

LTRIM$

MID$

PICK$

REPLACE$

REVCLNAM$

REVERSE$

RIGHT$

RTRIM$

SHADE$

SPACE$

STR$

STRIKE$

STRING$

STRIPHTML$

STRIPRTF$

SUBSTRING$

SWAPNAME$

TIMEZONE$

TOKENIZE$

UCASE$

ULINE$

UPTO$

USERID$

USERNAME$

VERIFID$

 
Time Functions:

BLANK_TIME

HOUR

ISBLANK_TIME

MINUTE

MKTIME

NOW

NOW$

SECOND

TIME$

TIMENUM

TIMETOUSERTZ

Note: Most of these functions are similar (if not identical) to dBase and Microsoft Basic functions.

See also:   Expression Examples
  Filtering Records
  Knowledge Base Article R11493 - All About Expressions
  Knowledge Base Article R11515 - Filter Expression Examples
  Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
  Knowledge Base Article R10733 - Expression Errors
  Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)