Quote:How can this work, when vUser and "LastLogin" are text strings? vLastLogin = @ToDate(@GlobalValue(vUser + "LastLogin"))
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:
* 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?
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