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!

[ChrisTX]

Try ELSE Null()

[Bren_Spill]

@greenman73 - The error says it's expression #2 which is the Select Column expression. Can you share that?

[DataNath · Accepted solution]

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!

[greenman73 · Accepted solution]

thank you!

[greenman73 · Accepted solution]

thank you!!! user error!

[greenman73]

thank you!!!!