Filtering by date and time

[sg@sfwater]

I am using Cognos 10.2 and I'm having trouble filtering the time associated with my date prompt.  I want to average the data for the date range picked on the prompt page from 12:01 AM to 11:59 PM.  This is what I have so far:

[History Version].[History Version].[Date/Time]between ?StartDate? and ?EndDate?

When I try to enter the time range I get an error.  Can anyone help with this?


Thanks

[MFGF]

I am using Cognos 10.2 and I'm having trouble filtering the time associated with my date prompt.  I want to average the data for the date range picked on the prompt page from 12:01 AM to 11:59 PM.  This is what I have so far:

[History Version].[History Version].[Date/Time]between ?StartDate? and ?EndDate?

When I try to enter the time range I get an error.  Can anyone help with this?


Thanks

Ummmmmmmmm.... Ahhhhhhhhhhh...... Mmmmmmmmmmmmm....

Nope. It's not working. My clairvoyance hat isn't giving me any success today, no matter how hard I try to focus my mind.

Sadly we're going to have to do this the good old-fashioned way. You're going to have to tell us what the error message is, as the hat is stubbornly refusing to work.

MF.

[Lynn]

[bdbits]

 ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D  ;D

[sg@sfwater]

error is  CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2016-12-23-08:59:54.174-#1577
OK

[Andrei I]

Please recreate the same issue in a simplified report against Cognos Samples and publish report source.

[bdbits]

sg@sfwater, when you get errors like that you need to have your admin check the cognos log, which will undoubtedly contain more information.

[prikala]

sg@sfwater, when you get errors like that you need to have your admin check the cognos log, which will undoubtedly contain more information.

And if your admin is feeling lazy, he/she can grant you the "Detailed Errors" capability.
Then you get the actual error message instead of "...Please contact your administrator. The complete error has been logged by..."
Saves time...