Automatically update a date to 5 days prior based on Due Date

Question

So, I have a due date entered and I want to automatically update a date 5 business days prior to that due date. Rather than me manually updated it, I'd like a formula to automatically update for me.

------------------------------
Vanessa Alexander
------------------------------

markshnier__you · Answer

no,
Just make a new Formula Date field called [5 Bus. days before Due Date ].

WeekdayAdd([Due Date],-5)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

vanessaalexande · Answer

You're awesome. Thank you so much!------------------------------Vanessa Alexander------------------------------

vanessaalexande · Answer

Hi Mark,I had to change the due date to include the time it's due. So, I'm using the Type as Due Date / Time, but now the formula is not working.&nbsp;This is the error I'm not receiving:Formula error -- Bad or missing arguments in function call

The types of the arguments or the number of arguments supplied do not meet the requirements of the function&nbsp;WeekdayAdd.The function&nbsp;WeekdayAdd&nbsp;can be used with the following arguments:

WeekdayAdd (Date d, Number n).
WeekdayAdd (WorkDate d, Number n).

You may need to do one of the following to fix the problem:

Choose the right number and type of arguments.
Use a type conversion function to convert the arguments you are using to the correct type.
Choose a different function.
------------------------------Vanessa Alexander------------------------------

markshnier__you · Answer

Assuming that you only care about the Date five days in advance and not the actual date and time then this would be the formulaWeekdayAdd(ToDate([Due Date]),-5)------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

vanessaalexande · Answer

Yes, this is perfect. Thank you and have a bless day------------------------------Vanessa Alexander------------------------------

Forum Discussion

Automatically update a date to 5 days prior based on Due Date

5 Replies