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.

4 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

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