Khaja_Zaffer
Esteemed Contributor

when using SQL to create a widget and set its default value to a previously declared variable, you should use a colon (:) prefix to reference the variable.

The correct syntax for your scenario is:

SQL
 
CREATE WIDGET TEXT date_end DEFAULT :date2;