formula

Syndicate content
Returns the last day of the period in which the date 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:
Returns the last day (Saturday) of the week in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
Returns the last day of the year in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
Returns the largest multiple of the duration y which is less than or equal to the duration x.
October 14th, 2009 - 4:10 PM
Tags:
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.
October 14th, 2009 - 4:10 PM
Tags:
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:

© 2016 QuickBase, Inc. All Rights Reserved.

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