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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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