If Then Statement

greenman73

Hello,

I am trying to get the day count between 2 dates when a cell in the same row says closed.

If Contains ([Incident Status], 'Closed') Then DateTimeDiff([Incident Last Resolved Date],[Incident Reported Date],'days') ELSE "" ENDIF

So if a cell in Column Incident Status says Closed then i want to calculate the different between Incident Last Resolved Date and Incident Reported Date.

I keep getting this error, in attachment

thanks!

Capture.PNG

DataNath

Hey @greenman73, there's nothing wrong with your expression here. The problem is that you've got another Formula expression in the tool and haven't given it a name. If you've made this by mistake then just delete it, or, if you're trying to make a new field or update an existing one then just set a name or choose the current field from the drop down!