Skip to main content
Question

isNull Help

  • August 16, 2017
  • 0 replies
  • 106 views

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 1: 11/30/16 Date 3: 12/31/17 OND/LED = 01/01/17

Example 2:
Date 2:                Date 1: 11/30/16 Date 3: 12/31/17 OND/LED = 11/30/16

Example 3:
Date 2:                Date 1:                Date 3: 12/31/17 OND/LED = 12/31/17

I tried this it didn't work:
If(isnull([Date 2],[Date 2]),isnull([Date 1},[Date 1]),[Date 3])
This topic has been closed for replies.

  • Quickbase Alumni
  • August 17, 2017
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.

  • Quickbase Alumni
  • August 18, 2017
If(
IsNull([Date1]) and IsNull([Date2]), [Date3],
IsNull([Date2]),[Date1])