302 Found

Found

The document has moved here.

Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • Returns the last day before 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:
  • This function returns d if d is not null. If it is null, it returns a 0-length duration instead. An undefined or empty field is "null." Null values don't work in 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:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead. 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.
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead.--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.
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead.--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.-
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead.--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.-
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead. 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.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns true if either a or b is true, otherwise returns false.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns what remains after excluding the leftmost n characters from the Text argument t.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns what remains after excluding the left part of a text value up to and including the first 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:
302 Found

Found

The document has moved here.