P
Paul
I am trying to report on login/logouts from a system and have a question.
4 fields that matter:
login_time Unix time the user logged in (ie..1168460873)
logout_time Unix time the user logged out
login_time_text Converted login time (1/10/2007 2:27:53 PM)
logout_time_text Converted logout time
logout_time has the potential to be 0, if someone doesn't logoff but is
disconnected from the system.
I have done 2 queries so far:
1. If the logout_time = 0, then logout_time = 'No Logout'
2. If the logout_time = 0, then logout_time = login_time + 3600 (1 hour)
What I really want to do is if the logout_time = 0, then add i hour to the
login_time and either change the color of the line or put smething like 'No
logout' in a different field that can be added to a report.
Hope this makes sense.
Thanx alot...Paul
4 fields that matter:
login_time Unix time the user logged in (ie..1168460873)
logout_time Unix time the user logged out
login_time_text Converted login time (1/10/2007 2:27:53 PM)
logout_time_text Converted logout time
logout_time has the potential to be 0, if someone doesn't logoff but is
disconnected from the system.
I have done 2 queries so far:
1. If the logout_time = 0, then logout_time = 'No Logout'
2. If the logout_time = 0, then logout_time = login_time + 3600 (1 hour)
What I really want to do is if the logout_time = 0, then add i hour to the
login_time and either change the color of the line or put smething like 'No
logout' in a different field that can be added to a report.
Hope this makes sense.
Thanx alot...Paul