Skip to Navigation

formula

Syndicate content
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.
October 14th, 2009 - 4:10 PM
Tags:
Counts the number of non-null arguments. For Text arguments, non-blanks are counted. For Boolean arguments, trues are counted.
October 14th, 2009 - 4:10 PM
Tags:
Creates a date from a year, month and day.
October 14th, 2009 - 4:10 PM
Tags:
Returns the day of the month of the given Date d.
October 14th, 2009 - 4:10 PM
Tags:
Returns the number of days by which the given date d follows the first day of the week (Sunday returns 0).
October 14th, 2009 - 4:10 PM
Tags:
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:
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:

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit