I posted this in "The Left Brain" but I think I should have placed it here in the calculation area of this forum.

A link is below to my original post - I am hopeful that someone can help me with the date formula/calculation...

Date Calculation - Turn around time?

This is dealt with here

http://fmforums.com/forum/showtopic.php?tid/176473

The calc should be in a calc field result number with the 'do not store box, evaluate as necessary' box checked.

This field does nor have to be shown anywhere but it will always contain the data that you want and can be used when and where ever

hth

Phil

ps Although you did not ask for it please be aware that this calc does not account for holidays. This issue is discussed here

http://fmforums.com/forum/showtopic.php?tid/187568/post/254220/hl/weekend/fromsearch/1/#254220

Thanks for your reply, I copy and pasted the formula into a calculation field and it came up with a few errors... I am completely new to this method of formula's and calculations so in some ways I am flying blind...

I have attached a picture showing the current database layout that we use and will explain what I am after. I understand the concept of only counting the weekdays and not weekends - which is what I would be looking to achieve.

Currently in all the red boxes with shading I have the current date in dd/mm/yyyy format "Received" and then the day of the week in the box next to it "RECEIVED". This is the same for the 'Artwork' 'Proof Out' and 'Modified' boxes.

I am trying to setup the calculation to be Proof Out minus Received which will give me a day range anywhere from 1 to X amount of days that the artwork has been turned around.

I would be looking to use the "Received" boxes on the left (in dd/mm/yyyy format), if the other boxes - RECEIVED - need to be deleted or removed I am more than happy to get rid of them.

My thanks to anyone that is able to help, I have taken a screen capture with the formula posted in a calculation - I hope that someone is able to assist me with this...

Regards and thanks, Shaun (Sticks1977)

Hi there

In the calculation replace the words 'start date' and 'end date' with the name of the fields that you wish to use.

Just for the record, why do you have 2 'received date' fields ?

Phil

Still no luck... I tried to swap over the 'Start Date' and 'End Date' with 'Received' and 'Proof Out' and it kept giving me this error:

[color:red]Either an operator was omitted, this function cannot be found, or "(" was not expected here

I am running Filemaker 5.5 here on a Mac, not sure whether v5.5 even has the capabilities to create a turn-around date for weekdays only.

Is there something that I am still not doing right? I even tried the other formula/calculation that was in the thread that you pointed me towards and I had the same error message.

Any help again would be appreciated - it is something that is bugging me and I am hopeful that I can find a result soon.

Regards, Shaun (Sticks1977)

Edited May 4, 200817 yr by Guest

Just for the record, why do you have 2 'received date' fields ?

There were two 'received' date fields as one of them contained the date in dd/mm/yyyy format and the other just had the day of the week according to the date "Mon-Fri".

I have tried the calculation to get a turn-around time by deleting the second received date and proof out fields but I get the same result unfortunately...

Regards, Shaun (Sticks1977)

This is because the above referenced material was for later versions of FileMaker. The Let () statement didnt come around until much later.

Try these old threads and see it they help.

http://www.fmforums.com/forum/showtopic.php?tid/116068

http://www.fmforums.com/forum/showtopic.php?tid/54679