Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
3 years ago

Is date null condition In Pipelines?

Is there a way to have a pipeline condition: If [Date] is null? I only can see to test if it is before or after a specific date.

For now, I have been making formula checkboxes and using the check box, which is quite annoying.



------------------------------
Mike Tamoush
------------------------------
  • DwightMunson1's avatar
    DwightMunson1
    Qrew Assistant Captain

    I am also looking into this for a pipeline. 

    What I have come up with so far, is that I have to use an advanced query to check that a date is set AND is not null. However, I'm not sure what that query would look like. I was thinking {FID.XEX.''} with leaving the value blank, but there is a difference between a text value being blank and a date value being null. 



    ------------------------------
    Dwight Munson
    ------------------------------
    • MikeTamoush's avatar
      MikeTamoush
      Qrew Commander
      After testing, I believe 'is set' and 'is not set' is what we are looking for. That seems to mean 'is not null' or 'is null', but perhaps someone can confirm.

      ------------------------------
      Mike Tamoush
      ------------------------------