incremental script problem

[riishabhz]

hi 

this is my script :-

max:
LOAD max (TransactionDate) as TransactionDate

FROM VWStockMovement_Qlik.qvd (qvd);

let vamxdater =Date(peek('TransactionDate',0,'max'));

drop table max;
final:
LOAD
NCode,
PartnerCode,
Channel,
ETPCode,
TransactionDate,
"Doc_Type",
TransactionNo,
Season,
Style,
Color,
Size,
TransactionQuantity,
ETPMRP;
SQL SELECT *
FROM ETPEASV55.dbo."VWStockMovement_Qlik" where TransactionDate>'$(vamxdater)';

Concatenate(final)
LOAD NCode,
PartnerCode,
Channel,
ETPCode,
TransactionDate,
Doc_Type,
TransactionNo,
Season,
Style,
Color,
Size,
TransactionQuantity,
ETPMRP
FROM
VWStockMovement_Qlik.qvd
(qvd);

i have used debugger also , please see my pics:-

i am getting this error , i have used double quotes also but its not working properly , any help?

[prma7799 · Accepted solution]

Try with this

let vamxdater =Date(peek('TransactionDate',0,'max'),'Your Date Format');

[riishabhz]

i changed to 

let vamxdater=Date(peek('SalesDate',0,'max'),'dd/mm/yyyy');

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Divide by zero error encountered.
SQL SELECT *
FROM ETPEASV55.dbo."VWStockMovement_Qlik" where TransactionDate>04/00/2019

what should i do now?

[prma7799]

How 0 is there in month 

 where TransactionDate>'04/?/2019'

[riishabhz]

i changed my dateformat and timestamp into this and now its working

SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YY h:mm:ss[.fff] TT';