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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Prompt from Macro - Convert from String->Date for performance
I had originally set up rptDate as a DATE datatype, but what I also had to do was reformat it in the macro before sending it to the report : RptDate = Format((Today - 1),"yyyy-mm-dd") Thanks for the help.- spichette
- Post #6
- Forum: Cognos solutions
-
Date Prompt from Macro - Convert from String->Date for performance
... B. If it is a Date field: Ensure RptDate is a date prompt. Your macro will still pass a string, but Impromptu will recognize it as a date..." That's what I was looking for !!! Thanks !- spichette
- Post #5
- Forum: Cognos solutions
-
Date Prompt from Macro - Convert from String->Date for performance
SyteLine / Progress is the Database.- spichette
- Post #3
- Forum: Cognos solutions
-
Date Prompt from Macro - Convert from String->Date for performance
With the help of this forum, I've been able to build a macro to run an Impromptu report (Ver.6), passing a date calculated within the macro, as a string "yyyy-mm-dd" to the fill-in prompt field in the .imr. Unfortunately, because of type conversions, the only way I've found to make the filter...- spichette
- Thread
- Replies: 5
- Forum: Cognos solutions
-
HP LH6000 with two nics
hatz101, I'm having the same problem with an LH6000r and a 3com NIC. The onboard NIC is recognized and works just fine. Have disk controllers in slots 6 & 8, tried the 3com in slots 1 & 2 and nothing. Using Windows Server 2000. Did you have any success getting the additional NIC to work? I...- spichette
- Post #3
- Forum: O/S Other general discussion
