Create date parameter for a command object

[kyzina]

I have three parameters in my SQL Command object report.

GROUP = '{?Group}'
STRM = '{?STRM}'

EFFDT = TO_DATE('?Date") this is not working, but when I put EFFDT = TO_DATE('2008-01-01') it's fine.

How can I create a date parameter for a command object?

Any suggestions?

thank you

 

[lbass]

Please do not cross-post or create multiple posts on the same topic.

-LB