Returns the last day of the year in which the date falls.

- Add new comment
- 32575 reads

Returns the leftmost n characters from the Text argument t.

- Add new comment
- 33014 reads

Returns the largest integer less than or equal to the number x.
Note that if x is a negative fraction, the result is closer to negative infinity than x is (compare to function Int).

- Add new comment
- 32750 reads

Returns the largest multiple of y which is less than or equal to x.

- Add new comment
- 38866 reads

Returns the largest multiple of the duration y which is less than or equal to the duration x.

- Add new comment
- 31595 reads

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
- 31605 reads

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

- Add new comment
- 32310 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
- 32440 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
- 38013 reads