302 Found

Found

The document has moved here.

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 milliseconds. This function takes a number and converts it into a Duration type value, expressed in milliseconds.
    October 14th, 2009 - 4: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 - 4:10 PM
    Tags:
  • Returns the logical negation of b (if b is true, returns false, otherwise returns true).
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns n characters from the middle of t, starting at position p. The first character is position 1.
    October 14th, 2009 - 4: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 - 4:10 PM
    Tags:
  • Returns the minute part of the argument t. The minute is in the range 0 to 59.
    October 14th, 2009 - 4:10 PM
    Tags:
302 Found

Found

The document has moved here.