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