formula

Syndicate content
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 leftmost n characters from the Text argument t.
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:
Returns true if the date d falls in a leap year.
October 14th, 2009 - 4:10 PM
Tags:

© 1997-2014 Intuit Inc. All Rights Reserved.

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