COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: priya1988nath on 21 Mar 2018 04:25:51 PM

Title: Best way to get last 2 hour in report studio
Post by: priya1988nath on 21 Mar 2018 04:25:51 PM
Hi all ,
I am using audit database to check what are reports failed in last 2 hours.I have used extract hour for this .But not satisfied with this code .Can you please let me know the best way to subtract 2 hours from  time stamp field?
I have already tried add_hour also . but it didn't worked out
Title: Re: Best way to get last 2 hour in report studio
Post by: sdf on 07 Aug 2018 12:07:02 PM
did you cast your add_hour to timestamp???