sullyman

Think i found it guys... Ignore the post. .Thanks

Hi folks, I had designed a working copy FMaker solution some time ago which was hosted on a trial FFMaker 9 Server. We didn't go ahead with the project and the trial server was deleted. I am now relooking at the solution again in Filemaker as i kept the FMaker Solution database fp7 file but when i try and open it now, it is asking for ODBC connections etc. which i can cancel and gain access to the solution but none of the data is there etc. I have another .bak file. I think this may be from the server. How do i recover this and can i open it locally with the data. Not the end of the world but it would be nice to see the solution with the test data i inputter previously. Any help appreciated. Thanks

Many thanks for your help Comment

Hi Comment, Thanks for your assistance with this and your attachment. Is this what you are doing in the enclosed file. 1. Enter Timestamp Date 2. Calc converts timestamp date to date 3. Function adds interval time to date and then converts it back to timestamp Thanks, Sully

This is as far as i got comment. Not sure how to proceed now. Could you take a look or is it even possible? test.zip

It kind of works but it sees the interval (weeks) field as seconds. So if i have a timestamp entry for the delivery_req date field of 17/07/2008 12:37:54, it calculates the Order Date as 17/07/2008 12:37:39 (Subtracting seconds instead of dates from it)

Thanks Comment. I will check. The only reason i need it as timestamps is that i'm connecting to an SQL database so the fields have to be timestamp fields instead of dates unfortunately

Can i have the Holiday field as a timestamp too and this would solve same?

Hi Comment. I have come across an issue with the function. I cannont get the function to work with my fields. I am using timestamp format instead of date field format. Is this the reason perhaps? Sully

Thanks again Comment. Much appreciated. Sully

Hi Comment, Thanks so much. That is absolutely brilliant and what i was trying to achieve. I changed the delivery_weeks * 7 to delivery_weeks * 5 in the Z_CalcOrderDate Calucation to calculate 5 working days back per week. Hope i am right here. It seems to work fine with the 5 option. Thanks again. Sully

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?

Thanks Comment. I see what you mean now but i still can't get it to work. I need to have a delivery Weeks field that substracts a delivery required date to give me an order date. i.e. a shipment is needed on site at a certain date. I now need to subtract a known expected delivery time (weeks) for this shipment to give me an expected date which i should order the shipment. Is this possible. I have attached the test file i'm trying to get it working. Any help would be appreciated. S Networkdate.zip

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

Hi Comment, I'm new to calling functions My calc is (Issued)-(Weeks * 432000) Is this how i would call the function? NextWorkDate (Issued)-(Weeks * 432000) Thanks, S

hi Comment, I am trying to get your function to work but i'm only a beginner with functions but have a grasp. I have created the function as pic attached shows. How do i now use it within a field calucation? I know i have to setup a table called listofholidays with dates of holidays etc. but how do i reference the function etc. Any help or a pic would be great if possible Thanks, S

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

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

I have unique records for Vendors where sometimes the RFQ No. for each could be the same. I have my subsummary template finished but i would like when the user goes to print that a dialog will pop up and ask them which RFQ No. they would like to print so FM will then preform a search and only pull out the records with the same RFQ No. in preview/print mode. Is this possible?

Not sure if this is the correct forum. I have several number fields that are used for inputting Money Figures? ie. $24,500 How do i get Merge fields to display the format as above. When i place the merge field on a report for this field, i am only receiving 24500 with no Currency format etc.

Is it possible to disable all shortcut keys? i.e. Ctrl F, Ctrl N etc. etc. Thanks, Sully

Hi, I've creted an ESS Script where i first set field, then commmit record, then grab another variable, and again set field and then commit the record again. Works well. Sully

Could well be a cul de sac but then the need for us to relay this to Filemaker to get the finger out and fix it!

The Forum needs you to dabble with this Soren to help us newbies :

Hi Soren, Thanks. Yes, it works fine. Unforunately this exact setup won't work with ESS and SQL Tables.