Jump to content
Sign in to follow this  
rwc.sheehan

Updating Records @ Login

Recommended Posts

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

Share this post


Link to post
Share on other sites

Are you storing the date of last login?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.