If statement

[Guest]

What am I missing here? I have the following if statement:

If MyRS.Fields("Date1").Value < Date And MyRS.Fields("Date2").Value = Null
Then
MsgBox "Late"
Else
MsgBox "On Time"
End If

Date1 and Date2 are date fields. The problem that I am having is that even
if Date2 is null, and Date1 is < today's date, the statement still evaluates
to "On Time" when it should be "Late".

Any help is greatly appreciated.

K

 

[Guest]

When you want to check if a value is equal to null then you should use
isnull([number], instead of Number=null

So try this
If MyRS.Fields("Date1").Value < Date And isnull(MyRS.Fields("Date2").Value)
Then

 

[Guest]

Thank you!

When you want to check if a value is equal to null then you should use
isnull([number], instead of Number=null

So try this
If MyRS.Fields("Date1").Value < Date And isnull(MyRS.Fields("Date2").Value)
Then

What am I missing here? I have the following if statement:

If MyRS.Fields("Date1").Value < Date And MyRS.Fields("Date2").Value = Null
Then
MsgBox "Late"
Else
MsgBox "On Time"
End If

Date1 and Date2 are date fields. The problem that I am having is that even
if Date2 is null, and Date1 is < today's date, the statement still evaluates
to "On Time" when it should be "Late".

Any help is greatly appreciated.

K

 

[David C. Holley]

Use IsNull() to test for null.