Skip to Navigation

Formula Function Reference

Our Formula Function Reference

WorkdayAdd - WorkDates

(WorkDate d, Numeric n)
Result Type: 
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.
WorkdayAdd([Order Date],7) returns the date seven days after the value in the Order Date field. WorkdayAdd(ToWorkDate(ToDate("10/31/2003")), 1) returns 10/31/2003 while WorkdayAdd(ToWorkDate(ToDate("10/31/2003")), 2) returns 11/01/2003


WorkdayAdd function

When I change my function from WeekdayAdd() to WorkdayAdd() I get an error message.  The parameters within the function are not being changed.  Any ideas why WeekdayAdd works but not WorkdayAdd?



Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit