Returns the fractional part of the Number n. The result is the same sign as n. For any Number n, Int(n) + Frac(n) is the same as n.

- Add new comment
- 48214 reads

Returns the hour part of the argument t. The hour is in the range 0 to 23.

- Add new comment
- 47648 reads

Returns a Duration representing n hours. This function takes a number and converts it into a Duration type value, expressed in hours.

- Add new comment
- 50676 reads

If condition1 is true, returns result1, otherwise returns else-result.
You can include additional condition/result pairs before the final else-result (as in the first example). QuickBase evaluates the conditions in sequence until one is found to be true, and then the corresponding result is returned.
The else-result is optional. If omitted, QuickBase assumes it's null (or empty - a blank).
All conditions must be of type Boolean (return a true or a false). Results may be of any type, but they must all be the same type.

- Add new comment
- 68394 reads

Returns the integer part of Number n.
Note that if n is a negative fraction, the result is closer to 0 than n is (compare to function Floor).

- Add new comment
- 52396 reads

Returns e raised to the nth power, where e is approximately 2.71828182845905
This exponential function is for use in logarithmic calculations that track growth. For example, you can use it to figure compounding interest.

- Add new comment
- 47921 reads

Returns the first day of the month in which the date falls.

- Add new comment
- 48595 reads

Returns the first day of the period in which the date d falls.
The cycle of periods is defined by the given Duration p, repeated in sequence starting at the given reference date r. If the period p is not a whole number of days, the fractional part is ignored.

- Add new comment
- 48505 reads

Returns the first day (Sunday) of the week in which the date falls.

- Add new comment
- 50394 reads