AnsweredAssumed Answered

Calculate a date using most recent date from several date fields

Question asked by on Jun 26, 2018
Latest reply on Jun 30, 2018 by taylorsharpe

Using FM Pro 13.

I publish an annual publication that is delivered to some locations up to 12 drops per year.

I have a delivery database in which I track deliveries. I have a preferred frequency set as number of days.

I can calculate a 2nd, 3rd, 4th, etc scheduled delivery drop by using ('18 1st Drop + Frequency), etc.

Problem is, not all of my drops require the same timespan, so some will have 4 drops when others have only received 1 or 2 drops. That means I'd have to schedule out 2nd, 3rd, 4th, 5th drops in fields that would take up too much space on my delivery list. See the image example. 2nd drop calculated on the left, current drops are on the right of the notes.

Screen Shot 2018-06-26 at 9.33.51 AM.png

Is there a way to ask Filemaker to look across ALL the delivery date fields ('18 1st Drop, '18 2nd Drop, '18 3rd Drop, etc) in the record and choose the Most Recent date?

Thanks in advance!