StevePolk Posted March 31, 2010 Posted March 31, 2010 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!
Søren Dyhr Posted March 31, 2010 Posted March 31, 2010 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now