Load Script - change field value

[Anonymous]

Hi,

how can i change the value in a loading script like this?

I try it by this way, but it shows that´s wrong:

tbl_sumApr:

LOAD

    sDate as newDate(['01.04.2017']),

    Product as newProduct,

    Sales as newSales

Resident tbl_jan;

regards,

sam

[sunny_talwar]

Looks right, what is the issue?

[swuehl]

Try

Date(Makedate(2017,4,1),'DD.MM.YYYY') as  newDate,

[Anonymous]

Thanks!

This works fine:

MakeDate(2017,4,1) as newDate