## Formula Function Reference

Our Formula Function Reference

## Formula Function Reference

• 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:
• Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
October 14th, 2009 - 4:10 PM
Tags:
• Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the date obtained by adding n days 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/01/2003 since it counts 10/31/2003 as 1 day and 11/01/2003 (a Saturday) as the second day.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the date obtained by adding n days 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/01/2003 since it counts 10/31/2003 as 1 day and 11/01/2003 (a Saturday) as the second day.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the year number of the Date d.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the year number of the Date d.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the user currently accessing the database.
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: