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:
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:

© 1997-2014 Intuit Inc. All Rights Reserved.

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