ASP question reading Null.

[Jgtdragon]

Hi Guys,
I am trying to write an if condition with null.

Here is my If statements:

If apriority = "P1" and ahour > 5 then
Cellcolor = "Red"

The one about works.

But if I want to add in a new field, due Date, it won't work.

I tried the following and all don't work.

A)If apriority = "P1" and ahour > 5 and aduedate = null then
Cellcolor = "Red"

B)A)If apriority = "P1" and ahour > 5 and aduedate = "" then
Cellcolor = "Red"

C) A)If apriority = "P1" and ahour > 5 and aduedate =" " then
Cellcolor = "Red"

I am just trying to add another condition telling it that if the due date field is empty then make the color red.

Please tell me what I am doing wrong. Thanks

 

[Jgtdragon]

I found it.

Its
If Isnull(aduedate)

🙂