boywonder Posted February 1, 2002 Share Posted February 1, 2002 I need to calculate end dates, and disclude weekends. I found this script on the web, but it's not working: DateField+Middle("1000002",MOD(DateField-DATE(1,3,1904),7+1,1) I suspect that the problem is with the date, but I'm not sure?? Also, how can I swith the date format to European standard day/month/year? Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted February 2, 2002 Share Posted February 2, 2002 Save yourself alot of trouble. go here http://www.databasepros.com/main/databaseprosflash.html Choose the resourse ball then enter WORK DAYS in search field Press yellow ball next to search filed Download Work days. Quote Link to comment Share on other sites More sharing options...
boywonder Posted February 3, 2002 Author Share Posted February 3, 2002 wasn't able to buy from database pros ... their site wouldn't respond ... but here's the answer (in case anyone needs it) If(IsEmpty(work duration);"";If(IsEmpty(work start date);"";work start+ Int(work duration/5) * 7 +Middle("12345012340123601256014560345623456"; (DayofWeek(work start) - 1) * 5 + Mod(work duration;5)+1;1))) Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.