The following works:
Code:
SET($[$12.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), GETDATE(), 120))
So this should also work:
Code:
Set ($[$12.0.DATE]|SQL: SELECT CONVERT(VARCHAR(10), DateAdd(DD,30,GETDATE()),120));
The main reason is that the date has to be in format YYYY-MM-DD
Comments
1 comment
HANA:
@STORE1 = SQL(SELECT TO_VARCHAR(T0."DocDueDate", 'yyyy-mm-dd') FROM "ORDR" T0 WHERE T0."DocNum" = 972);
SET($[$12.0.DATE]|@STORE1);
Please sign in to leave a comment.