Post

3 followers Follow
0
Avatar

Syntax Error

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

Outdoorfactoryaustralia Answered

Please sign in to leave a comment.

5 comments

0
Avatar

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.

Guy 0 votes
Comment actions Permalink
0
Avatar

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

 

Bea Genthner 0 votes
Comment actions Permalink
0
Avatar

Thanks Bea and Guy. Bea I tried your formula and this is the error

 

Set Run Time

Run On:
Run Repetitively
Formula Options
 
DATEDIFF(TODAY(),$StartDate,"D") > 7
Check Syntax

Error: Invalid function Today() usage in current context

 

It seems that no matter what I try an error will occur.

Daymon

Outdoorfactoryaustralia 0 votes
Comment actions Permalink
0
Avatar

Hi,

Would you please send me a screen capture where you apply the formula?

Bea Genthner 0 votes
Comment actions Permalink
0
Avatar

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

Rachel Gomez 0 votes
Comment actions Permalink