Updating Records @ Login

[rwc.sheehan]

A little something that's been givine me a headache...

I have a database full of records. The field active keeps track of which records are active, and automatically updates itself once a record passes its expiration date. I would like to know when any record goes sour so I can assess whether it needs to be renewed. I want to setup a script that runs at login(no problem there) that will check if any records have expired since the last time I logged in, and hopefully tell me which one (although that can be found out with minimal detective work if it cannot be scripted).

Any takers on this one? I know how to setup a script to run at login but I don't know what functions to use. I've tried a few things but no luck so far.

Thanks

[-Queue-]

Are you storing the date of last login?

[rwc.sheehan]

I am not currently but I could if necessary.

[-Queue-]

I would think it necessary if you want to compare expiration dates to the last login date.

[rwc.sheehan]

oh thats true...i was just trying to compare it to what had changed since last login date. however, you're correct. if i compare the expiration date to the date of last login that would make much more sense. i'll go ahead and try that. thanks