Using the following formula
$StartDate+days(7)
in New Scheduled Workflow Rule for : 'Work Item' it keeps on throwing up this error Error: Invalid input found: '$StartDate' does not matter if it is sourced from the Formula Options window or hand typed.
I am trying to trigger an email 7 days after the Start Date of a project
Please sign in to leave a comment.
It will not work as you need the same data types. Tried to look around it, couldn't find anything yet, but will keep looking.
In the meantime, if projects start typically on Monday for example, you can create a scheduled workflow and have it run on Friday/Sunday, for example.
Hi,
Please try the following syntax:
DATEDIFF(TODAY(),$StartDate,"D") > 7
DateDiff(dateTime1,dateTime2,interval) - returns the intervals between two dates in number. The 'interval' parameter is a string that should contain one of the following: “y” (for years), “m” (for months), "d" (for days) or "w" (for weeks)
Please let me know if it works.
Thank you,
Bea
Thanks Bea and Guy. Bea I tried your formula and this is the error
Set Run Time
Hi,
Would you please send me a screen capture where you apply the formula?
If a syntax error appears, check to make sure that the parentheses are matched up correctly. If one end is missing or lined up incorrectly, then type in the correction and check to make sure that the code can be compiled. Keeping the code as organized as possible also helps.
Greeting,
Rachel Gomez
