2.0

Functions
Using Calculations - 235
Hour
The Hour function returns the hour (HH) portion of a given time
(HH:MM:SS). The hour is based on a 24-hour clock and ranges from 0– 23.
Usage Example
Hour(Time())
If the current time is 18:05:05
Then the calculation Hour(Time()) returns 18
In the example below, the hour is taken from the
Time
field and put in
the
Hour
field.
If
The If function evaluates a logical expression and returns the true
expression if it evaluates to true (“yes” or “true”). Otherwise, it returns
the false expression.
Usage Example
If(log exp,true exp,false exp)
If the field [Monthly Sales] = 5500
Then the calculation If ([Monthly Sales]>5000,”Good work!”,”Let’s work harder
next month!!!”) returns the string “Good work!”
In the example below, a text string is placed in the
Comment
field based
on the value for the
Monthly Sales
field.