Thank you so much for the help it return correct values. One more doubt, i got Now last logout name of employee ,but supposed after some time he logged in again now i need to remove this user from my logout list. Can you please help me. Supposed i have employees data status Like login logout. I need to calculate the how many employee logged in and logged out. 3 employees login and from that 3 employee One log out. Now I need to count in logout list. Suppose again the same employee login i need to push it into login list and remove from logout list likewise
... View more