Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default date in Prompt

Status
Not open for further replies.

rcaesar

MIS
Sep 5, 2002
92
US
Is it possible to get rid of the default 0000-00-00 in a date prompt. I would like it to be blank.

Thanks
 
rcaesar,

See FAQ401-2137 under the heading of "General Picklist Limitations". To do this you would have to use a macro or make the prompt a string and convert it to a date in the report. This often results in a performance hit in the report, especially if there is a lot of data.

Regards,

Dave Griffin



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
[pc2]
Want good answers? Read FAQ401-2487 first!
 
Thanks Dave

The performance issue is something I will have to consider.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top