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]

You should be able to simply use:

EFFDT = {?Date}

...as long as EFFDT is a date field, and the parameter has been set up as a date type parameter.

-LB

 

[kyzina]

Thank you for your reply. I saw your name all over the site!

The funy part is :when I set the {?EFF Date}parameter to the string and did that:EFFDT = TO_DATE('{?EFF Date}') it's working perfectly fine now.

 

[lbass]

I think you are taking two extra steps--converting a date parameter to a string and then back to a date. If EFFDT is a date, then my previous suggestion should work as well.

-LB