Isnull not working in calculated column of attribute

[former_member224444]

Hello All,

I am trying to check Null value of the date field in calculated column of attribute view, but it is not working.

IF( isnull("TODATE"),'PRESENT','')

I am expecting 'PRESENT' in STATUS field if TODATE is null.

Thanks,

Rithika

[former_member229997]

Please check data type of To_Date.

Regards,

Chintan

[former_member224444]

Hi Chintan,

I use DATE type for the TODATE field for which am checking isnull.

Thanks,

Rithika

[former_member229997]

First thing, if you are changing value of as string type , You need to change data type of To_Date column as varchar.

Or else You need to create another calculated columns which data type as VARCHAR and apply your formula, Let me know what is status.

Regards,

Chintan