due date formula based on priority ...help
[Priority]=1,[Due Date] Today() + Days(1) [Priority]=2,[Due Date] Today() + Days(2) [Priority]=3,[Due Date] Today() + Days(3) [Priority]=4,[Due Date] Today() + Days(4) [Priority]=5,[Due Date] Tod...
Forum Discussion
Take out the parenthesis that have numbers inside them. Make it like this:
"[Date Created]+Days([Priority])". Sans quotes.
this ^^^ is the only line of code you need.
if(
dayofweek([Date Created]+Days([Priority]))=6,
[Date Created]+Days([Priority])+2,
dayofweek([Date Created]+Days([Priority]))=0,
[Date Created]+Days([Priority])+1,
[Date Created]+Days([Priority])
)
So this code adjusts the Due Date to Monday if the Priority date lands on a Saturday or a Sunday. 0=sunday, 6=Saturday. The default value will be Date Created plus priority days.