1 Reply Latest reply on Jan 17, 2017 2:32 AM by beverly

    Turnaround Times minus the Weekends and Holidays


      Hi Teams,

      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.