Forum Discussion
Not getting the max expected value
Hello Greg_Deckler
Like this?
id issueid created LastRelease
85304 10451 25/01/2017 15:51 FALSE
85341 10451 25/01/2017 16:04 FALSE
378810 10531 26/09/2017 13:19 FALSE
419087 10531 02/11/2017 17:07 FALSE
497931 10531 22/01/2018 18:16 FALSE
499825 10531 24/01/2018 18:21 FALSE
140026 10532 17/03/2017 17:05 FALSE
303169 10532 12/07/2017 17:06 FALSE
419137 10532 02/11/2017 17:56 FALSE
498667 10532 23/01/2018 16:24 FALSE
91089 10536 31/01/2017 16:00 FALSE
91092 10536 31/01/2017 16:00 FALSE
79506 10543 18/01/2017 19:22 FALSE
79505 10544 18/01/2017 19:21 FALSE
280843 10544 21/06/2017 12:57 FALSE
319832 10544 01/08/2017 15:53 TRUE
319833 10544 01/08/2017 15:54 FALSE
79517 10546 18/01/2017 19:44 FALSE
140020 10546 17/03/2017 17:03 FALSE
303159 10546 12/07/2017 17:01 FALSE
419116 10546 02/11/2017 17:24 FALSE
497932 10546 22/01/2018 18:17 FALSE
501003 10546 25/01/2018 17:49 FALSE
This should solve the issue.
Thanks abhishekpati86, but not exactly, because I want the last created date for an issueid, and in your solution I have 4 entries to issueid 10544.
I think you are talking about the below similar issue. I hope it helps.
Hello abhishekpati86
I was just testing you solution from the other post, but I have still not the solution.First I can not add more columns (or at least doens't know how);
Second Lastdate function returns only the date, and I need the datetime. (the original value in the column)
How can I overcome this?