This content has been marked as final. Show 3 replies
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):
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 !