Search results for query: *

Dear user community, I have 2 database fields that consist of date/time formats. I want to see the time difference expressed in hours when I subtract the "recent" date from the "older" date. Example 1 --> 08/11/2009 16:00 - 08/11/2009 14:00 should result in 2 hours Example 2 --> 08/11/2009...

drlex, I tried out your formula and it threw an ORA-01722 error. According to http://ora-01722.ora-code.com/ this means that the attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only numeric fields or character fields...

drlex, Will your formula also convert the time as well? Thanks!

Dear user community, I have a database field defined as a string with example content of '06/30/2009 15:15' (quotes not included in database field). My challenge is to perform date caculations using this date converted string in such a way that I can substract another date. I suspect that it...

drlex, Worked like a charm. Thank you.

drlex, Thank you for this reply. I will attempt this filter option.

Dear user community, I wanted to ask your professional opinion on an automated Cognos Impromptu application close once a scheduled report ran successfully in Cognos Impromptu. I am aware of options such as defining the application close in a macro, allowing Cognos only to startup once...

Dear community, I would like to request your help with Cognos Impromptu 7.4 scheduled reports. A client asked me to create a filter that would show a list of data between e.g. 11PM last night and 7AM this morning. I know how to do this with regular prompts but need some guidance on how to...