ContributionsMost RecentMost LikesSolutionsRe: Minimum Due Date Based on End of Quarter DateThe plan was to just populate a date in the [Quarter End Date] spot you outlined below and manually update that four times a year in this one date formula field. Will this work? Also, in terms of setting up the variables this is something I haven't done before. Do I make the variables directly in the date formula field or is this something I'd have to do separately outside of that field and then reference? If this isn't an easy answer, if you could point me to any articles discussing it in the support pages that would be appreciated. Again, thank you for your help! ------------------------------ Josh Baker ------------------------------ Re: Minimum Due Date Based on End of Quarter DateHey Jordan, Thank you for the below that all makes sense to me. The last item I wanted to see if there is a solution for is below. We've made it past the quarter end date of 7/31/20. Once we update the quarter end date in the formula to a new date in the future (say 10/31/20) wouldn't this update all the prior records that had a due date populated and were then subsequently checked off as complete to a Null value? I would like the system to populate the due date once and not update the date in the field once it's been checked off as complete. Hope that makes sense, if not I can provide a more detailed example. Thanks for all your help! ------------------------------ Josh Baker ------------------------------ Minimum Due Date Based on End of Quarter DateHello! I'm looking to create a date field formula that returns a due date that is 10 business days after a creation date field (this is auto populated based upon the recorded added date) or a static end date (the end of our fiscal quarter). I would also like this calculated date to be made static if the record has been already review by checking a checkbox. An example is below. Scenario 1: Quarter End Date: 7/31/20 Date Created: 6/18/20 Returned Due Date: 7/2/20 (+ 10 business days from Date Created) Scenario 2: Quarter End Date: 7/31/20 Date Created: 7/23/20 Returned Due Date: 7/31/20 (<10 business days from Date Created but not further than quarter end date) I know I'll need to use a min function but I'm unsure how to set up the formula. I'm guessing I'll have to add a calculated due date field that calculates the above and then populates the due date field with the due date if the checkbox is not checked off. Any help would be appreciated. Thanks! ------------------------------ Josh Baker ------------------------------ Re: Rich text field data entry width not honoredI too have this issue and would like an update, it's annoying that it spreads across the screen. ------------------------------ Josh Baker ------------------------------ Re: How do I modify my existing formula date field to exclude weekends?That worked perfectly! Thank you!Re: How do I modify my existing formula date field to exclude weekends?Scenario: I'm trying to calculate a review due date based off the system date created field that doesn't fall on a weekend. I also would like to be able to edit the result as the due dates may need to be updated. I'm trying to use the [Date Created] field in the WeekdayAdd function above and I'm getting the following error message. 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 functionWeekdayAdd. The functionWeekdayAddcan 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. What am I doing wrong?