Add days to date in table while loading from excel

[ikenna94]

Hello All,

I am trying to load data from an excel file into my QLIK app and at the same write a script to add a new column in my table plus 70 days ahead. I tried using this syntax below but, did not work.

DatesTable:

LOAD

Name,

lastname,

OldDate,

OldDate + 70 AS NewDate  

FROM [******************xls]
(***********************);

[Channa · Accepted solution]

try date(datefield +70)

[pradosh_thakur · Accepted solution]

DatesTable:


LOAD


Name,

lastname,

OldDate,

date(num(OldDate) + 70) AS NewDate  


FROM [******************xls]
(***********************);

Make sure your date are in proper date fromat and not in string format

If it is in string format you may have to change it to

date#(olddate,date_format) and then use that to get the new date.

Regards

Pradosh

[ikenna94]

Good Stuff. It works.