Substitution variable dates

[Drillnot]

It looks like date type substitution variables are evaluating the input unlike previous versions like 15.

According to Help, section 12.3, under "Type option",

No validation will occur for date values, so that the user can additionally supply date expressions like sysdate, trunc(sysdate, ‘MM’) and so on.

When I enter "sysdate" for the following query in a SQL window:

select &<name="inputDate" type="date"> as "UserInputDate" from dual;

the bottom of the popup Variables window displays

'sysdate' is not a valid date and time

Running the same query in v15 will output the current system date and time.

 

[Marco Kalter]

It seems that this is indeed not working as expected. We'll fix it!

 

[Drillnot]

I confirmed 16.0.0.2135 now allows date substitution variables to handle expressions as well as literal date formats. Thank you, Marco!