Solved

SharePoint 2010 InfoPath (Codeless) Default Due Date 2 Working Days into Future using XPath

Posted on 2013-10-28
3
1,141 Views
Last Modified: 2013-11-18
Hi,

There is a page out there that I cannot find, that I did find at one point, that helps you set your default due date to two working days in the future (holidays not accounted for - just Saturdays and Sundays) using XPath only.  I know about this post by alec: http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

There was a post that would essentially use XPath to look at the current day.  I believe this is how the post worked or how I think it should work: Since I want to add two business day from the date created, If created on Thursday, it would be due on Monday (add 5 days to Today). If created on Friday, add 5 days to [Today] to make it due on Tuesday.  If Created on Saturday (shouldn't happen but does), then add 4 days to  [Today] to make it due on Tuesday.  If Created on Sunday, then add 3 days to [Today] to make it due on Tuesday.

It may be more accurate to calculate 48 hours ahead then the eqivalent for 24 hours for each weekend day.
0
Comment
Question by:atljarman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Assisted Solution

by:clayfox
clayfox earned 225 total points
ID: 39605332
There is the built in function addDays() but it does not consider weekends or business days.
there is code that will do this but the only other option I know that is codeless is to create a list with first column startdate, next column 2daysout. If you have any other increments you could have columns for those too.
best way is to create a spreadsheet, I think Excel has the ability to calculate this, and then import the spreadsheet as a list.

create a receive data connection to the list and create a filter that sets due date with 2daysout where today() equals startdate.

hope that helps.
0
 

Accepted Solution

by:
atljarman earned 0 total points
ID: 39644168
Thanks.  I was never able to implement this but appreciate the suggestion.  Maybe it will help someone else
0
 

Author Closing Comment

by:atljarman
ID: 39655863
Not able to implement due to change in direction nor able to verify that the suggestion works.  Assigned points based on merit.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question