Hi,
I am having trouble writing an expression within a SQL Query for a Date prompt.
I am using the Date Prompt with a range - how do I reference this in my query.
For example: my value prompt macro(parameter named - ReadCode is referenced as - see below - works perfectly)....
Where Code = #prompt('ReadCode')#
is it along these lines:
to_date(#sq(prompt("Sdate","date"))#,'YYYY-MM-DD') and to_date(#sq(prompt("Edate","date"))#,'YYYY-MM-DD')??????
any ideas?