Does anybody know what I can do to get a maximum of certain date field that includes hours and minutes as well.
1111 Dec 15, 2016 2:30 Pm
1111 Dec 15, 2016 1:00 Pm
For the same exact record id.
Pls help if you can. Very important.
Thanks :) :)
Quote from: gosoccer on 26 Oct 2017 01:05:57 PM
Does anybody know what I can do to get a maximum of certain date field that includes hours and minutes as well.
1111 Dec 15, 2016 2:30 Pm
1111 Dec 15, 2016 1:00 Pm
For the same exact record id.
Pls help if you can. Very important.
Thanks :) :)
Hi,
Yes - what issues are you experiencing?
Go to the Toolbox tab, drag in a query calculation, and set the expression to be maximum([your date time field] for [your record id])
Cheers!
MF.
Well, that's what I used but the Cognos Server was timing out and go even dispather error. It seems like
with a little dups involved, the Cognos 10 is chocking. It seems like Cognos 11 (Analytics) is doing so much better for
the same query in "Report"
Trying it this morning with less users involved.
Thanks
No luck after using the maximum([your date time field] for [your record id]). The dates are based on different Hours and Minutes and not dates. I think that's maybe why it is not working.
In some cases, it is a minute off between the latest and the one before.
Thanks for your time
Quote from: gosoccer on 30 Oct 2017 01:03:00 PM
...The dates are based on different Hours and Minutes and not dates...
Are you saying the values are just times with no dates?
MF.
The values are date and time but I figured it out. The following did the trick.
maximum(distinct [Data Item], for Unique Record ID)
I took off the column that was causing the duplication from the listing also.
Thanks, for your time