How to work with Date format in SQL: Set command

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