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

Are you storing the date of last login?

I am not currently but I could if necessary.

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

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