formula

Syndicate content
Returns the date that is n weekdays past the given date d. n may be negative to move backward in time.
October 14th, 2009 - 4:10 PM
Tags:
Returns the date obtained by adding n weekdays to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/03/2003 since it counts 10/31/2003 as 1 day and 11/03/2003 (a Monday) as the second day.
October 14th, 2009 - 4:10 PM
Tags:
Returns the number of weekdays in the interval starting with d1 and ending on the day before d2 (same as subtracting Dates, but the result is the number of weekdays instead of a Duration). It is the inverse of WeekdayAdd.
October 14th, 2009 - 4:10 PM
Tags:
If the given date d is a weekday returns it, otherwise returns the previously occurring weekday.
October 14th, 2009 - 4:10 PM
Tags:
Takes a Duration d, and returns the number of weeks contained in it.
October 14th, 2009 - 4:10 PM
Tags:
Converts a date d to a WorkDate.
October 14th, 2009 - 4:10 PM
Tags:
Returns t with leading and trailing white space characters removed. White space characters are space, tab, CR and LF.
October 14th, 2009 - 4:10 PM
Tags:
Returns t converted to upper case.
October 14th, 2009 - 4:10 PM
Tags:
Encodes the text t so that it can be used in a URL, by substituting special character combinations for certain reserved characters, like '&' and '=' and space.
October 14th, 2009 - 4:10 PM
Tags:
Returns the first part of the URL used to access QuickBase, including the protocol and the site name.
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