Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Looks right, what is the issue?
Try
Date(Makedate(2017,4,1),'DD.MM.YYYY') as newDate,
Thanks!
This works fine:
MakeDate(2017,4,1) as newDate