Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'd like to set the value of "Due Date" on "Create Custom Task" within my workflow.

However, I want it to be "weekend aware"...i.e. (Sunday-Thursday working week)
if you create a task on Sunday to Tuesday then its due 2 days later
if you create a task on a Wednesday then its due Sunday
if you create a task on a Thursday then its due Monday

I have looked at workflow variables, but these don't have calculations.
I have looked at "Do Calculatation" but this is very restricted to "add a fixed number"

[Yet again, a simple task in SharePoint proves to be difficult]

share|improve this question

2 Answers

up vote 1 down vote accepted

It's not as simple as one could wish, but you can do it by using the following actions as building blocks:

  • Use Find Interval Between Dates to get the number of days from a know date to the create date
  • Use Do Calculation (mod 7) to get the week day of the create date
  • Use a series of if any value equals value togetter with Add Time to Date to calculate the due date
share|improve this answer
Wow! Marked answer as correct...but there is no way I will actually build this! I can't beleive how poor a product SharePoint is!...Well played whoever sold it to my company - puppy springs to mind :( – BlueChippy Nov 6 '12 at 4:16

Without custom code, I can see no way of doing it on with de SPD.

Best regards.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.