You cannot specify the date or number format of a substitution variable. A date ot number must conform to the current Windows format.
You can however convert from a specific format in your query. For example:[quote]
select * from emp
where hiredate > to_date(&<name="Hiredate" type="string">, 'dd.mm.yyyy')
[/quote]
------------------
Marco Kalter
Allround Automations