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 - 4: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 - 4:10 PM
    Tags:
  • Returns a Date / Time value representing the current moment.
    October 14th, 2009 - 4: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 - 4: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 - 4: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 - 4:10 PM
    Tags:
  • Returns n modulo m. (Mod is the same as Rem for positive numbers, but different for negative numbers.)
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the month number of the Date d. January is month 1.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the millisecond part of the argument t. The millisecond is in the range 0 to 999.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns a Duration representing n milliseconds. This function takes a number and converts it into a Duration type value, expressed in milliseconds.
    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