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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Prompt in Custom SQL Report
Thanks for such a quick response, Dave. We have been playing with the idea of using a string prompt. However, we cannot seem to get the syntax correct. We are using a DB2 database and the error we get when we do what you suggest is: ... The syntax of the string representation of a datetime...- MFraz
- Post #3
- Forum: Cognos solutions
-
Date Prompt in Custom SQL Report
Has anyone tried to put a date prompt in an Impromptu Report that is created using a Custom SQL statement? I have a complicated SQL statement that uses a string prompt, a numeric prompt and a date prompt. The string and the numeric work fine, the date does not. If I hardcode the date in the...- MFraz
- Thread
- Replies: 5
- Forum: Cognos solutions
