7 Replies Latest reply on Nov 19, 2009 2:16 PM by david583

    Dispatch Date calculation



      Dispatch Date calculation


          FMPro10, Shared, Windows 

      I'm trying to create a calculated date for dispatch.
      Each of our customers have a specific day of the week for dispatch (text value DayName). This is held in a CUSTOMERS table, related to an ORDERS table by an ID number.
      When a date is entered into a [date_complete] field in the ORDERS table, I want to calculate the next dispatch day for that customer, and add this to a [dispatch_date] field.
      This would take the complete date [from ORDERS], find the customers next dispatch day [from CUSTOMERS]and calculate the [dispatch_date].
      Is this possible? I am having a lot of trouble coming up with a calculation to do this.