I need to find maximum of date for everyday. Actually, if a user logs in multiple times in day. then I need to show last login date with time .
Any input plz .
Ari
What's wrong with the "maximum"-function?
Just using a max on the date will not automatically give the max date for EVERY user individually. You either should define a ranking on the date against the user and then use a aggregate filter or write a complex filter involving the max..
We've had a similar issue not a long while back, so a quick search on rank / ranking would give you some ideas to work with..
I'm not sure what's the problem with "maximum". We did this alread with the same goal, getting a timestamp of the latest user's action, showing all users. And this was solved with a query calculation & the maximum function.
the following will get the max of logindatetime per date.
maximum(loginDateTime for date)
the following will get the max of logindatetime per user per date.
maximum(loginDateTime for username,date)