The context is a to-do (Action) list system. Some Actions, when done, will trigger another instance of the completed Action with DateDue on a future date. How far in the future may be a number of days or weeks or months. Assigning a new date exactly n days or weeks or months in the future us easy. I…

You may find that this post provides an answer. [image] Calculate Working Days (Business Days) between a Date Range Need help Thank you @romanmg !!! Superhero, as usual.

Thanks, Dan. I’ll study this and give it a go. I don’t think this will work when I am ready to skip over holidays. That will require a holiday calendar but the Air Date/Time Picker approach may get me started.

True, it likely wont work for the holidays part. But here’s a quick idea: you could create holidays as a database record that works in tandem with this. (Ie. a holiday has the fields of name and date. Add in a boolean field is_weekend (or is_excluded) and account for any matching holidays within tha…

Dan, Hopefully I’ll have time this weekend to put this idea to the test.

Set a Future Date, Skipping Weekends

Need help

dan1 May 22, 2018, 3:37am 2

You may find that this post provides an answer.

Topic		Replies	Views
Setting future date automatically Need help	3	449	August 5, 2020
Time/date format question Need help	2	782	August 16, 2016
Calculate a date (skipping weekends) Need help	2	733	April 17, 2019
Number of days between 2 dates excluding weekends Need help	3	4451	September 26, 2020
Set a workflow to run next week on a Friday Need help	2	357	February 23, 2023

Set a Future Date, Skipping Weekends

Related topics