i need help about warning message with date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ga3la
    New Member
    • Jan 2010
    • 1

    i need help about warning message with date

    I have project to do, but really i'm very confiose for much things i must to do. for that i come here to ask for help if anyone have little time and be patient

    well let me talk about the i mportant:

    i do the basic things, and left the complicate things left it help from you.

    what i'm looking for:

    i have database wih customers, there are two tables one loyal customers and other free customers, everything i need just applicate of loyal customers.

    - i need like warning every 6 mounths show message box warning there is some customer make 6 mounths and need make notes. in same time the warning stay active because maybe i wasn't able to check the program in the same day that have some customer already make 6 mounths, stay the message warning apear till i make notes and in same time already start counting for next warning 6 mounths.

    P.S : if you see the loyal customers, there are some customers have two contrat or more just for same customer

    thank you so much for by attention and try help
    Attached Files
    Last edited by NeoPa; Jan 17 '10, 10:25 PM. Reason: Removed bold for whole post
  • TheSmileyCoder
    Recognized Expert Moderator Top Contributor
    • Dec 2009
    • 2322

    #2
    Well you could add a field to your tables called something like dt_LastChecked and have that field set everytime you update the post.
    Then all you need to do is run a query on all posts that are older then 6 months.

    Comment

    Working...