Discussions

Expand all | Collapse all

isNull Help

  • 1.  isNull Help

    Posted 08-16-2017 17:16
    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])


  • 2.  RE: isNull Help

    Posted 08-17-2017 15:19
    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.


  • 3.  RE: isNull Help

    Posted 08-17-2017 15:22
    Chuck this is the error I recieved:
    Expected a valid expression after the "&"


    If((isnull([OND Extension]) &  & isnull([OND]),[LED],
    if(isnull([OND Extension]),[OND], [OND Extension])))


  • 4.  RE: isNull Help

    Posted 08-17-2017 15:26
    Try that

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


  • 5.  RE: isNull Help

    Posted 08-17-2017 15:29
    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 


  • 6.  RE: isNull Help

    Posted 08-17-2017 15:32
    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!


  • 7.  RE: isNull Help

    Posted 08-17-2017 15:36
    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">https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6">https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6 


  • 8.  RE: isNull Help

    Posted 08-17-2017 16:06
    Thanks so much for your help


  • 9.  RE: isNull Help

    Posted 08-18-2017 07:17
    If(
    IsNull([Date1]) and IsNull([Date2]), [Date3],
    IsNull([Date2]),[Date1])