Member Avatar for bettybarnes

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

  • 4 Contributors
  • 6 Replies
  • 247 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by NETProgrammer
Member Avatar for Pgmer

Maonths.Add function u have to use

Member Avatar for Pgmer

Sorry i was wrong. here is the code.

select dateadd(month,2,getdate())
Member Avatar for sandeepparekh9

SELECT DATEADD(MONTH,2,'06/08/2011')

will give you your answer...

Member Avatar for Pgmer

Hi Sandeep,

I also gave the same answer right? I just said Getdate() instead of exact date.

Member Avatar for sandeepparekh9

yes. its the same.. but i thought he would understand quickly that way.. :)

Member Avatar for NETProgrammer

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.