I’m putting together a database to run a gas servicing programme. I need to run a query that looks at the previous service date and then generates a next service date that is ten months after the previous service date. The only complication is that I need it to avoid weekends (and holidays as well if possible!)
Thanks in advance!