MS Project 2013 - Custom Field Formula Syntax Error

[Paulmnz]

I'm creating a report view in MS Project 2013 Standard, which is intended to show tasks due in the next two weeks.
I got the formula from here:

http://www.cambermast.com/agile-ideas-create-kanban-board-microsoft-project/

(([Start]>DateAdd(“d”,-14,now()) Or [Finish]>DateAdd(“d”,-14,now())) And ([Start]<DateAdd(“d”,14,now()) Or [Finish]<DateAdd(“d”,14,now()))) Or ([Finish]<DateAdd(“d”,14,now()) And [% Complete]<100)

I get a 'Syntax error' - "Formula contains a syntax error or an unknown field or function'
Clicking 'OK' to highlight the error, highlights "d" in the first DateAdd function as the issue.

Any suggestions on cause and solution?

 

[remeng]

Hi Paulmnz

Can you explain what the goal is of the code? I think I understand what you are going for, but I want to make sure that we are on the same page.

Thanks,

Mike

 

[combo]

I have no MS Project, but at a first look the quotation marks in the formula seem to be non-standard, try to replace them by regular ".


combo