Skip to Content
0
Nov 21, 2017 at 02:50 AM

Isnull function not working for Date

1806 Views Last edit May 26, 2020 at 06:43 PM 2 rev

Hi All,

Could you please let me know if the Isnull function in a calculated Column will work for the Date Field.

For example: I have a Field A with Date Type as Date, I created another Calculated Column with formula "isNull(Field A)". If I have a null value then the calculated column should show as 1 else as 0, right? But I'm getting 0 in spite they are Null Or populated.

Attaching a test view which I created with the same formula

I'm currently using HANA2.0 SPS 2 version

Attachments

datetype.png (7.1 kB)