## Formula Function Reference

Our Formula Function Reference

## Formula Function Reference

• Returns the hour part of the argument t. The hour is in the range 0 to 23.
October 14th, 2009 - 4:10 PM
Tags:
• Returns a Duration representing n hours. This function takes a number and converts it into a Duration type value, expressed in hours.
October 14th, 2009 - 4:10 PM
Tags:
• 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.
October 14th, 2009 - 4:10 PM
Tags:
• 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).
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if d is February 29.
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if the date d falls in a leap year.
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if the year y is a leap year.
October 14th, 2009 - 4:10 PM
Tags:
• Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.--The result of this function is true if x is null, otherwise false. The argument x may be of any data type (except text or boolean).
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if x is the email address of the current user.
October 14th, 2009 - 4:10 PM
Tags:
• 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).
October 14th, 2009 - 4:10 PM
Tags: