8 Replies Latest reply on May 15, 2017 9:48 AM by mikemccabe29

    Case statement not working when inserting 'and' ...

    mikemccabe29

      I have  a  Case statement that I can’t get to work.

      Case ( (not IsEmpty (Foote_YCAT_date) and IsEmpty(custom_gesell_ca_date) ); 1 ;

            ""

           )

       

      When I split it up, I get TRUE / “1” both times.  When I combine it, the result is “”

       

      BOTH of these individually return a 1:

      Case ( IsEmpty ( custom_gesell_ca_date ) ; 1 ;

            ""

           )

       

      Case ( not IsEmpty ( Foote_YCAT_date )  ; 1 ;

            ""

           )

       

      However, when I combine them:

      Case ( (not IsEmpty (Foote_YCAT_date) and IsEmpty(custom_gesell_ca_date) ); 1 ;

            ""

           )

       

      I get “” / NULL

       

      Both fields are defined as date fields.  Any ideas? 

      custom_gesell_ca_date = “”

      Foote_YCAT_date  = 01/11/2016

       

      Thanks