formula

Syndicate content
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:
Returns the millisecond part of the argument t. The millisecond is in the range 0 to 999.
October 14th, 2009 - 3: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 - 3:10 PM
Tags:
Returns the first day after the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on.
October 14th, 2009 - 3:10 PM
Tags:
Returns the logical negation of b (if b is true, returns false, otherwise returns true).
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