Dear all,

I created in field text1 the countdown formula: DateDiff("d",Date(),[Finish]) and this works well. I have certain rows not indicating a Finish date and then resulting in Text1 as an #ERROR. I tried to implement an IF function, but below ones are already dissaproved in the formula input field. Anyone an idea how to hide an #ERROR?

IIF([FINISH] = “ “ , “ “ , DateDiff("d",Date())

IIF([Text1] = #ERROR , “ “ , DateDiff("d",Date())