7 Replies Latest reply: Nov 20, 2017 5:11 AM by Victor GREFFET RSS

    empty missing

    Victor GREFFET

      Hey community,

       

      Still stuck on that field :

       

      if(len(trim(Release_DateBIS))=0,'empty',if(len(trim(Release_DateBIS))>10,date(right(Release_DateBIS,10)),date(Release_DateBIS))) as Release_Date,

       

       

      I'm trying to do that :

      • Release_DateBIS=0 --> 'empty'
      • len(trim (Release_DateBIS)) > 10 --> date(right(Release_DateBIS,10))
      • len(trim (Release_DateBIS)) = 10 --> Take Release_DateBIS


      it almost works, i have blank cells instead of 'empty' when storing the Tab.


      Do you have an idea ?


      Thanks !