By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,081 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,081 IT Pros & Developers. It's quick & easy.

i need help about warning message with date

P: 1
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
File Type: zip (1.43 MB, 38 views)
Jan 16 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 100+
P: 2,321
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.
Jan 16 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.