AnsweredAssumed Answered

Dispatch Date calculation

Question asked by david583 on Nov 17, 2009
Latest reply on Nov 19, 2009 by david583


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.