2 requirements for if statement?

[WinDancer]

The syntax I asked about here in this forum, for a filter, won't work with my if statement-

What I am trying to do is run code if the case status is any status except closed OR with no date in the date completed field.

This code won't run correctly:

If "[CaseStatus]<>'Closed' or NOT IsNull([DateCompleted])" Then

Help, please?

Thanks,
Dave

 

[boblarson]

Get rid of the double quotes

If "[CaseStatus]<>'Closed' or NOT IsNull([DateCompleted])" Then

should be

If [CaseStatus]<>'Closed' or NOT IsNull([DateCompleted]) Then

Or


If [CaseStatus]<>"Closed" or NOT IsNull([DateCompleted]) Then

 

[WinDancer]

Thanks again, Bob.
7 paydays left
Dave