AnsweredAssumed Answered

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

Question asked by mikemccabe29 on May 9, 2017
Latest reply on May 15, 2017 by 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

Outcomes