Omitting Weekend/Holidays Date

[sullyman]

I have three fields in Filemaker Pro.

Issued ++ Weeks ++ Field Date

People enter a date (Drop Down Calendar) entry in the Issue Field and enter a number (e.g. 1, 2, 3, 4 etc.) in the Weeks field. I have the following calculation (Issued)+(Weeks * 432000) which then caluclates the Field Date.

e.g.

20-07-08 ++ 2 ++ 30-07-08

The issue i come across is that this caluclation does not take weekends or holidays into account. Is there a way i can force the field date calculation to exclude falling on a weekend day or holiday?

Thanks,

Sully

[Søren Dyhr]

This should get you going!

http://www.briandunning.com/cf/721

http://www.briandunning.com/cf/760

...remeber to read about required CF's too!

--sd

[sullyman]

Hi Sd,

I've tried to copy both Functions to FM File>Manage>Custom Functions but it won't except either?

S

[sullyman]

Trying to following the following function

http://www.briandunning.com/cf/795

How do i set $$holidaylist at Startup and reference a table with future holiday listings please

[Lee Smith]

The First one, http://www.briandunning.com/cf/721 copies right in.

The second one,

Requires that you have already created two other CFs see comments (

Requires Custom Functions: "ShipByDate" by Tim Flynn and "DateRange" by Andrew Persons--thanks to them for their work.)

http://www.briandunning.com/cf/722 ([color:blue]Be aware, that the CF has an error in the name, and you do not need [color:red]Name ( param ; param ), [color:blue]and it will not read with it.

http://www.briandunning.com/cf/8

I have made a sample of these, hope it helps you.

Lee

sullyman_CFs.fp7.zip

[sullyman]

Thanks Lee. The examples work great and i am following them the best i can.

What is the best way to change the Transit Days in DateShipByHolidays Layout to Transit Weeks as i need the transit field to calculate by weeks excluding weekends?