View Single Post
 
Old 10-24-2013, 01:20 PM
dbsoccer dbsoccer is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2012
Posts: 21
dbsoccer is on a distinguished road
Default

This appears to be a great solution. My German is not good so I can't read what is on the link.

I muddled my way around and discovered how to add a custom field and am trying to understand what to do based on the pictures and not the German. I have copiedthe formula and am getting a syntax error, the semi-colon just before the first [Start]. If I change the semi colon to a comma, the syntax error moves to the next semi-colon.

IIf(2,6*DateDiff("d";[Start];[Finish])+1-(len([Name]))>0;space(2,6*DateDiff("d";[Start];[Finish])+1-(len([Name]))) & [Name];[Name])

Any thoughts on what I am doing wrong?
Thanks.
Reply With Quote