SUMMARY
The following is a list of functions that you can use in the Works Database:
ABS(x)
ACOS(x)
ASIN(x)
ATAN(x)
ATAN2(x-coordinate,y-coordinate)
AVG(Fieldname0,Fieldname1,...)
CHOOSE(Choice,Option0,Option1,...)
COS(x)
COUNT(Fieldname1,Fieldname2,...)
CTERM(Rate,FutureValue,PresentValue)
DATE(Year,Month,Day)
DAY(DateNumber)
DDB(Cost,Salvage,Life,Period)
ERR()
EXP(x)
FALSE()
FV(Payment,Rate,Term)
HOUR(TimeNumber)
IF(Condition,ValueIfTrue,ValueIfFalse)
INT(x)
ISERR(x)
ISNA(x)
LN(x)
LOG(x)
MAX(Fieldname1,Fieldname2,...)
MIN(Fieldname1,Fieldname2,...)
MINUTE(TimeNumber)
MOD(Numerator,Denominator)
MONTH(DateNumber)
NA()
NOW()
PI()
PMT(Principal,Rate,Term)
PV(Payment,Rate,Term)
RAND()
RATE(FutureValue,PresentValue,Term)
ROUND(x,NumberOfPlaces)
SECOND(TimeNumber)
SIN(x)
SLN(Cost,Salvage,Life)
SQRT(x)
SUM(Fieldname1,Fieldname2,..)
SYD(Cost,Salvage,Life,Period)
TAN(x)
TERM(Payment,Rate,FutureValue)
TIME(Hour,Minute,Second)
TRUE()
YEAR(DateNumber)
In addition, Works 3.0 and later include the following text and logical
functions:
AND(logical1,logical2,...)
EXACT(Textvalue1,Textvalue2)
FIND(FindText,SearchText,Offset)
LEFT(TextValue,Length)
LENGTH(TextValue)
LOWER(TextValue)
MID(TextValue,Offset,Length)
N(RangeReference)
NOT(logical)
OR(logical1,logical2,...)
PROPER(TextValue)
REPEAT(TextValue,Count)
REPLACE(OldText,Offset,Length,NewText)
RIGHT(TextValue,Length)
S(RangeReference)
STRING(x,DecimalPlaces)
TRIM(TextValue)
UPPER(TextValue)
VALUE(TextValue)
NOTE: There are some extra functions which can be used, but which do not normally make sense in the context of the database list or form views.
These are ROWS(), STD(), VAR(), COLS() and NPV(). Although you can enter
these functions and get a value, in most cases the material you would want
to use them on would be across records. However, you can correctly use the
STD() or VAR() function in a database by entering it into the Summary or
Summ row of a database report.