Hello Scott,

You can use the On Application Open event for this and store the user's last login date in a GlobalValue. Below is an Example of how to do this. The user will get a message if they have not logged in for over 7 days.

Var vUser as String
Var vLastLogin as Date
Var vToday as Date

vUser = @UserID
vLastLogin = @ToDate(@GlobalValue(vUser + "LastLogin"))
vToday = @ServerDate()
If vToday > (vLastLogin + 7) Then
{
	Writeln("You have not logged in for " + @Str(@ToNumber(vToday - vLastLogin)) + " Days")
}
GlobalValue(vUser + "LastLogin",vToday) 

-Ray

OK, I incorporated the programming into On Application Open, but set the time limit to vLastLogin + 1, so it should fire off tomorrow.  A few questions in the meantime:

* How can this work, when vUser and "LastLogin" are text strings? vLastLogin = @ToDate(@GlobalValue(vUser + "LastLogin"))


* A new scenario:  Sammy has been on vacation, which I have been unaware of since such things are the province or personnel and payroll and not MIS.  However, I am the admin of the database he uses.  Sammy is supposed to return to work today, at which time he will get the important message the above programming is designed to give him.  However, he has not returned to work today (maybe he's sick), so the message never was seen and the action he's supposed to accomplish has not occurred.  This is something that I, as admin, need to know.  How should I tweak the programming so that if Sammy hasn't logged in on day 8 a message is sent to me when I log in?

Thanks for your help Ray.

Quote:


Let's say vUser is Sammy that will resolve to

vLastLogin = @ToDate(@GlobalValue("Sammy" + "LastLogin")) 

which becomes

vLastLogin = @ToDate(@GlobalValue("SammyLastLogin")) 

So Sesame returns the value from the GlobalValue named "SammyLastLogin

Quote:


That becomes a bit more complicated. Do you want the message if any user has not logged in over 7 days or only certain ones? If it's all users, You can use @ItterateGlobalValues() along with @SearchStringArray() to get the names of all the GlobalValues that end with the string "LastLogin". Once you have the list of GlobalValue names you can loop through using @AccessStringArray(), @CountStringArray() and @GlobalValue() to grab the value from each GlobalValue. Then compare that value with today's date and display a message if needed.

-Ray

Infinity wrote on Apr 5^th, 2011 at 2:43pm:


Hello Scott,

Initialize them to today's date. 734232 I believe is the number of days from 00/00/0000 to today.

-Ray