isNull Help

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
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])
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
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.
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Try that

If((isnull([OND Extension]) AND isnull([OND]),[LED],
if(isnull([OND Extension]),[OND], [OND Extension])))
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb
A closing parenthesis is missing.


If((isnull([OND Extension]) AND isnull([OND])  ,[LED],

if(isnull([OND Extension]),[OND], [OND Extension])))

I already try added just two parenthesis 
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb
I added one after OND and removed one from the end, Checking now to see if it works properly

Thanks so much for your help!
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Yeah keep playing with it I think you're close. This is a handy thing to have open when constructing these.
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6 
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb
Thanks so much for your help
Photo of Kevin

Kevin

  • 260 Points 250 badge 2x thumb
If(
IsNull([Date1]) and IsNull([Date2]), [Date3],
IsNull([Date2]),[Date1])