topic Re: Fill empty date field in App Development

Fill empty date field

victor_greffet — Mon, 23 Oct 2017 14:59:32 GMT

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

Re: Fill empty date field

antoniotiman — Mon, 23 Oct 2017 15:02:10 GMT

May be

Load

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

Re: Fill empty date field

sunny_talwar — Mon, 23 Oct 2017 15:02:47 GMT

Try this

Load

If(Len(Trim([Target Date])) = 0, 'empty', Date([Target Date])) as [Target_Date] ,

...

From Excel file.xlsm

Re: Fill empty date field

victor_greffet — Mon, 23 Oct 2017 15:46:04 GMT

It works,

You're awesome

Thank you !