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
Assuming your [Due Date] field is a formula date field.
and your [Priority] field is a numeric field....
You can simplify this greatly.
Today()+Days([Priority])
However, using the "Today()" option will constantly update/change the due date, because Today's date always changes.
I'd recommend using a static date, like Date Created, or some other date that the user enters.
and your [Priority] field is a numeric field....
You can simplify this greatly.
Today()+Days([Priority])
However, using the "Today()" option will constantly update/change the due date, because Today's date always changes.
I'd recommend using a static date, like Date Created, or some other date that the user enters.