I am trying to show a due date that is 14 BUSINESS days in the future based on a date in a seperate field. I have this formula, @Adjust(FieldName;0;0;14;0;0;0) but it doesn’t exclude the weekends. How do I get this to work excluding the weekends?
Subject: Field date adjustment on a Form
Search in the R5 forum - there are many posts (with answers and code) on this topic there.
Stephen Lister
Subject: RE: Field date adjustment on a Form
There is a new @function called @businessdays which will return the number of business days between two dates.