Multi-Field Formula - Invalid Type Operator

[MatthewBr]

Any reason this error message is appearing at the bottom of the multi-field formula?  If I run the workflow it runs with no errors or warnings.

Expression:

if [_CurrentField_] > [Fiscal Month End] then null() else [_CurrentField_] endif

[mst3k]

Your text input tool has a blank row in the 3rd row, and your fiscal month end in row 2 is not a complete date, just 2018-

I don't actually see an error message when I open it or run it, but those things above cause the multifield to evaluate as null

[MatthewBr]

sorry I deleted the row and 

Very bizarre.

[Emil_Kos]

Hi @MatthewBr,

Nice to meet you.

I think you need to change the data type of the Fiscal month End to date

[danilang · Accepted solution]

Hi @MatthewBr 

Welcome aboard.  I think you may have found a bug!

Leaving only the first row in your input forces all fields to be dates so the config in your Multi-Field should work and it does if you run it.   If you change all the fields to strings, and select the Text Fields from the drop down, the error goes away and it runs properly as well. 

From what I know about how Designer interacts with the runtime engine when you're making changes to a workflow, Designer take the data from the first record and passes it to the runtime engine and parses the result that comes back.  This happens on every keystroke, which is why the error status is dynamic.   It looks like the engine is returning a false positive about a field type match error.   

Dan