Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5409 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I need to calculate days between dates excluding weekends and company holidays. I have a StartDate and EndDate in my initial database. Do I need to set up a lookup table listing the company holidays and how would that look in a calculation? Any help anyone can give me would be greatly appreciated!

Posted

There are almost as many methods as developers to this question, however would I for starters use this function:

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

...and then pay slight attention to leading and trailing pilcrows before ValueCount( -'ing...

There is BTW another solution, here:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000639

--sd

This topic is 5409 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.