Recent News
|
InnPlanner 2010 Released
New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... | |
InnPlanner 2010 RC1
InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. |
|
|
Hotel Software Documentation
List of Functions
Formula Editor
- Functions |
Math/Logic Functions
Abs - Returns the absolute value
Cos - Returns the value specifying the cosine of an angle
Exp - Returns e (exponent) raised to the power of a value
If - Returns 1 if expression is true, 0 otherwise
Int - Returns the integer portion of a number
Log - Returns the value specifying the natural logarithm of a value
Pow - Returns base raised to the power of exp.
Round - Returns the rounded value to specified precision
Sgn - Returns the number indicating the sign of a value
Sin - Returns the value specifying the sine of an angle
Sqr - Returns the square root of a number
V - Returns the value of a variable
Know more...
Date Functions
dateSerial - Returns the date for the specified year,
month, and day
datePart - Returns the specified part of the
date
dateCurrent - Returns the current system date
dateDiff - Returns the interval between two dates
dateAdd - Returns the date shifted from date to a specified interval
Know more...
Data Functions
F - Returns the value of a field of the current record
RF - Returns the value of a field of
the specified record
FLen - Returns the length of a field of the current record
User - Returns user input
Know more...
Functions for Recordset
Returns result of operation (sum, avrage, etc) for records from:
folMathOp - specified folder
mmrMathOp - many-to-many field
setMathOp - recordset stored in variable
queMathOp - query results
repMathOp - report
subMathOp - grouped records in a report
cexMathOp - custom export
Returns number of records in:
folRecN - specified folder
mmrRecN - many-to-many field
setRecN - recordset stored in variable
queRecN - query results
repRecN - report
subRecN - grouped records in a report
cexRecN - custom export
Know more...
See Also:
Formula Editor
Script Designer
|
|
|
|
Today"s Poll
What software do use for your inn/b&b/hotel/etc?
|
About