How to pass a start and end dates from a macro to a prompt

[mrstyxjdm]

I'm using a smarthotfile that prompts for a start and end date. However, I need to launch the report from a macro, and pass in the start and end date. So far, I have not found a way to do this. Please help. Thanks.

 

[drlex]

Assuming you're using a CognosScript Macro, and that by smarthotfile, you mean an Impromptu report run against a hotfile, put the start and end dates (formatted for your locale) in a string with a pipe character ('|') between them

"2009-01-06|2009-06-20"

should pass 1st June 2009 & 20th June 2009 to a prompted report.

soi la, soi carré