## Formula Function Reference

Our Formula Function Reference

## Formula Function Reference

• Returns the number of days by which the given date d follows the first day of the year (January 1 returns 0).
October 14th, 2009 - 4:10 PM
Tags:
• Returns a Duration representing n days. This function takes a number and converts it into a Duration type value, expressed in days.
October 14th, 2009 - 4:10 PM
Tags:
• Returns a Text value containing the database ID of a table.
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if the text u ends with the text v, otherwise returns false.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the average of all the arguments (except any null values).
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if the text u begins with the text v, otherwise returns false.
October 14th, 2009 - 4:10 PM
Tags:
• Case() is a variation of the If() function. If you want to test many conditions against a single field, use the Case() function instead of the If() function. QuickBase evaluates the value x and compares it to each of the values that follow (val1 and so on) sequentially. If the value X matches any value, QuickBase returns the corresponding result which lives behind the comma following the matched value. If value x is not equal to any of the values, QuickBase returns the else-result at the end of the formula. The else-result is optional. If omitted, QuickBase assumes it's null (empty). The value x may be of any data type, but all of the values must be of the same type as x.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the smallest integer greater than or equal to the number x.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the smallest multiple of y which is greater than or equal to x.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the smallest multiple of the duration y which is greater than or equal to the duration x.
October 14th, 2009 - 4:10 PM
Tags: