finding maximum of date

[ari_meta]

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

[IceTea]

What's wrong with the "maximum"-function?

[blom0344]

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..

[IceTea]

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.

[tiga123]

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)