isNull Help
Made a new field "OND/LED" I want this field to show the following result if DATE 2 is blank show Date 1 if date 2 and date 1 are blank show date 3. For Example Example 1: Date 2: 01/01/17 Date ...
Forum Discussion
Think you have some broken syntax.
If((isnull([Date 2]) && isnull([Date 1]),[Date 3],
if(isnull([Date 2]),[Date 1], [Date 2])))
Not tested so my syntax may be a bit off but think its close.
If((isnull([Date 2]) && isnull([Date 1]),[Date 3],
if(isnull([Date 2]),[Date 1], [Date 2])))
Not tested so my syntax may be a bit off but think its close.
Try that
If((isnull([OND Extension]) AND isnull([OND]),[LED],
if(isnull([OND Extension]),[OND], [OND Extension])))
If((isnull([OND Extension]) AND isnull([OND]),[LED],
if(isnull([OND Extension]),[OND], [OND Extension])))