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
2 comments
HANA:
@STORE1 = SQL(SELECT TO_VARCHAR(T0."DocDueDate", 'yyyy-mm-dd') FROM "ORDR" T0 WHERE T0."DocNum" = 972);
SET($[$12.0.DATE]|@STORE1);
Hi,
I need the below to say IF ($[$BOYX_5.0.0] > yesterday:
What is the correct logic please?
Please sign in to leave a comment.