If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to write #prompt macro for Date Range Prompt

Started by rb_bassi, 20 Mar 2008 10:26:57 AM

Previous topic - Next topic

rb_bassi

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?