3 Replies Latest reply: Oct 23, 2017 11:46 AM by Victor GREFFET RSS

    Fill empty date field

    Victor GREFFET

      Hi community,

       

      I have an Excel Data base and I loaded different column. In order to have the date format in my app, I used the date function , but at the same time I wanted to fill empty cells with 'empty'. I have this script (exemple for one column):


      DATA :


      Load

      date(if(len(trim([Target Date]))=0,'empty',    [Target Date])) as     [Target_Date] ,

      ...


      From Excel file.xlsm


      But after storing DATA, I realized that I only have dates and nothing when the cell is empty. It works if I remove the function date() but my dates are like numbers


      do you have an idea ?



      Thank you !

      Victor