hi guys i know this is just a very simple but i do not know to get started..
im developing a loan mng't system wherein the starting application of the customer say for example today. 06/08/2011, the initial payment will be on 08/08/2011.. how am i going to that do on sql server 2005? any help pls.. thanks
bettybarnes
7
Posting Whiz in Training
Recommended Answers
Jump to PostMaonths.Add function u have to use
Jump to Postyes. its the same.. but i thought he would understand quickly that way.. :)
All 6 Replies
Pgmer
50
Master Poster
Featured Poster
Maonths.Add function u have to use
Pgmer
50
Master Poster
Featured Poster
Sorry i was wrong. here is the code.
select dateadd(month,2,getdate())
sandeepparekh9
109
Posting Whiz
SELECT DATEADD(MONTH,2,'06/08/2011')
will give you your answer...
Pgmer
50
Master Poster
Featured Poster
Hi Sandeep,
I also gave the same answer right? I just said Getdate() instead of exact date.
sandeepparekh9
109
Posting Whiz
yes. its the same.. but i thought he would understand quickly that way.. :)
NETProgrammer
-3
Light Poster
Simplest way is
TextBox2.Text = DateTime.Parse(TextBox1.Text).Date.AddMonths(2)TextBox2.Text= Where you need the output
TextBox1.Text= Where user enters date
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.