Wrong number of parameters in expression

Good afternoon,

I am attempting to write an expression through the formula tool and continue to get an error message that reads "wrong number of parameters for the function Null". I have written these types of expressions in the past and have never run into this issue. I am guessing that it is a relatively easy fix which I am unable to determine what to change. Any help would be greatly appreciated.

Thanks!

Data Investigation

Accepted answers

Maskell_Rascal

Hi @MHS

When referencing a date field, you need to put quotes around the date in your formula.

IF [Field1]>= '2020-03-19' THEN '2020.07' ELSE Null() ENDIF

Thanks!

Phil

All comments

mceleavey

Hi @MHS ,

Are you trying to input a null value as the last clause? if so, drop the "0" from in the parentheses. Just null().

MHS

Hi @mceleavey,

I attempted that earlier and get a different error message of "Invalid type in operator >=". I have tried to change up the greater than or equal to portion, but cannot get rid of the error message?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703