Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • Returns what remains after excluding the rightmost n characters from the Text argument t.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns what remains after excluding the right part of a text value starting at the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns a Date / Time value representing the current moment.
    October 14th, 2009 - 3:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns 0 instead. An undefined or empty field is "null." Null values don't work in numeric calculations, which is where the Nz() function comes in handy. When Nz() finds a null, it sees it as a zero. So, if you want to perform calculations on a field that may include a null, use the Nz function.
    October 14th, 2009 - 3:10 PM
    Tags:
  • This function can take 2 or more arguments of any data type, as long as they are all the same type. The result is the same data type as the arguments. Null values are ignored. For Numbers, returns the argument that is least. For Text, returns the argument that sorts first alphabetically. For Durations, returns the argument that is shortest. For Dates returns the argument that is earliest. For Date/Time, returns the argument that is earliest. For TimeOfDays, returns the argument that is earliest. For Booleans returns the argument that is smallest, treating false as less than true.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns the minute part of the argument t. The minute is in the range 0 to 59.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns a Duration representing n minutes. This function takes a number and converts it into a Duration type value, expressed in minutes.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.) You might use this function to auto-assign tasks to staff members. For details, please read Article #308 in the QuickBase KnowledgeBase
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns n modulo m. (Mod is the same as Rem for positive numbers, but different for negative numbers.)
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns the month number of the Date d. January is month 1.
    October 14th, 2009 - 3:10 PM
    Tags:

© 1997-2014 Intuit Inc. All Rights Reserved.

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