I saw you're answer from a few years ago and found this very interesting, and although one kind person has answered there answer did totally bamboozle me as I'm new to FMpro, and am learning things as I go along.
Please help me understand this as this would really help with my Turnaround Times by excluding weekends and Holidays. I've also never done relationships before so can you explain in simple terms what I need to do.
To explain what I have at present:
Field Name: Field Type:
Date Product Arrived Date
Date Order Arrived Date
Date of Shipping Order Date
TAT (Turnaround Time) for Order Date
Turnaround Time Calculation (But shows as a number of days not a date) The calculation is "Turnaround Time =Date of Shipping Order - TAT for Order"
So at present my TAT for Order field chooses the nearest marker between Date Product Arrived and Date Order Arrived as my TAT starts when I receive both ( I could have the product in stock before the order comes through and vice versa) This gives the result in Turnaround Time Field, but I want to exclude Bank Holidays and Weekends.