IsNull ?

[#1]

IsNull([Start_Date])=0 means..

[MK_QSL]

It will check if Start_Date is Null...

[its_anandrjs]

Hi,

Isnull returns

Returns -1 (true) if expr returns NULL, otherwise 0 (false).

Thanks & Regards

[veidlburkhard]

Hi Helen,

the QV help file sais: IsNull() Returns -1 (true) if expr returns NULL, otherwise 0 (false)

Hope this helps.

Burkhard

[senpradip007]

IsNull(<YourField>) = 0 means when <YourField> contains not null value the function returns 0 and -1 when it cpontains null.

[#6]

can you explain with an example...

Thanks

Helen

[CELAMBARASAN]

To add with it

It can be used simply

If(Not IsNull([Start_Date]), expr, expr)

Which is easily understandable, instead of writing those equal conditions its likely to compare.

[its_anandrjs · Accepted solution]

Hi,

In this line means in [Start_Date] field if value is there means IsNull returns 0 and if value is not there(IsNull) then it returns -1

IsNull([Start_Date])=0

Try to plot a text box and write below code and you check this

=if(IsNull([Start_Date]) = 0, 'Date is there','Date is not there')

Thanks & Regards