rember befor tow or forth day

i use visaule basic 2005  
in y tabel  there are colum (date)

i want show msgbox before 30 day  in
specific  date  
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dirk HaestProject managerCommented:
Look at the methods available in the DateTime object, there is an AddDays-method that does exactly what you want.


' Calculate what day of the week is 30 days before today.
Dim today As System.DateTime
Dim answer As System.DateTime

today = System.DateTime.Now
answer = today.AddDays(-30)

System.Console.WriteLine("{0:dddd}", answer)

Open in new window


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ziayd2009Author Commented:
u r example  i s good but
i have  tabel have many date start from 1-01-2011 to 30-0302011
if we in third month   i want my  program give  the dates  befor three or fore days
E.X name  the customer  when  the rent  end before three days in  30-0302011?
sara 27-0302011  
jak 27-0302011  
toom 27-0302011  
Dirk HaestProject managerCommented:
Do you want a query to retrieve all the correct rows ?
What database are you using ?
Is the date-format from here above correct ?
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

ziayd2009Author Commented:
I've requested that this question be deleted for the following reason:

Dirk HaestProject managerCommented:
Why do you want to delete the question ? You didn't answer my questions
Dirk HaestProject managerCommented:
The initial question is solved by #35232298 . The other small follow-up questions are unanswered because the poster didn't give feedback to the experts. So my suggestion is to accept #35232298 as an answer
Robert MarleySinger / SongwriterCommented:
I am starting the Auto-Close procedure on behalf of the question asker, to close this question, after the 'Objection' by Dhaest stopped the procedure. Following Moderator review, it would appear answers were provided, even though it may not necessarily have been what you wanted to hear.

Everyt'ing is everyt'ing,

Community Support Moderator
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.