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 :


      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 !