duration between dates

[cfor]

Looking for some help with date calculations.

I have a start date and an end date (defined as dates). I need to calculate the workday duration between the 2 days and also figure out a way to exclude holidays.

I'm guessing it needs to be a custom function, but I don't know how to do that.

thanks

[mr_vodka]

See if these threads help.

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

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

[cfor]

Thanks, I looked at those before I posted. My problem is that I can't figure out how to convert those answers into what I'm trying to do.

I think I understand the Holiday part. I get lost in the difference of using 2 dates and figuring out the workday durations.

[comment]

I don't think a custom function is really needed here. See:

http://www.fmforums.com/forum/showtopic.php?tid/155958/post/156042/#156042

For holidays, you need to define a relationship to a table of holidays, filtered by by the date range. Then count the holidays in range* and subtract the count from the previous result.

---

(*) make sure you count only holidays that fall on what would otherwise be a workday.

[-Queue-]

See if this helps. http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=5281

[comment]

Yikes, that's an ugly one.

[LaRetta]

I agree, Michael. Even the one *I* wrote is better than that!

[-Queue-]

Agreed, but the search engine seems too complicated these days. So I just went with what I had, even though I was still beaten by a minute.

[comment]

Still rusty, eh?

[-Queue-]

Thanks, but it probably will just get me wet for now. I've only used FM 5.5 for the last two years; we really need to upgrade to 9, which may become a reality within the next year. I need some time to play with 7 again, but that probably won't be happening very soon.

Cry for me, won't you?

[comment]

What are you - Argentina? I am sure you'll manage. Off topic, I always thought FMI should offer a FREE developer version (perhaps crippled in some way to prevent abuse).

[-Queue-]

No, I'm not quite that big yet, but you could still be sympathetic, ya jerk!

Ooh, that would be excellent! It would definitely beat changing the date before you open any files, not that I've ever done that...

[comment]

I was referring to your attitude, not your size. Never had much patience for other people's self-pity - too preoccupied with my own. :)

[-Queue-]

Okay, now I'm addicted. Thanks a lot!

[cfor]

Thanks for the help! I'm working my way through it. I think I can get it up and running now.