DaniWeb Forum Index > Web Development > JSP

Add month in date

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 11

Reputation: shweta797 is an unknown quantity at this point

Solved Threads: 0

shweta797

Offline

Newbie Poster

Add month in date

May 27th, 2008

Dear sir
In my project i have to show amount of all the months i.e if user enter first due date and expiry date then it calculate the amount of all the months which are between first due date and expiry date in reports. in Jsp how a month can be added in a table date value.
if my filelds are :

 Help with Code Tags 
 Java Syntax (Toggle Plain Text) 
java.sql.Date duedate=rs.getDate("firstrentduedate");
 
java.sql.Date expirydate =rs.getDate("expiryofrent");
while(duedate .after(expirydate))
		  {
duedate=duedate+'addmonth'
}
java.sql.Date duedate=rs.getDate("firstrentduedate");
		 
java.sql.Date expirydate =rs.getDate("expiryofrent");
while(duedate .after(expirydate))
		  {
duedate=duedate+'addmonth'
}

plz help

Last edited by peter_budo; May 27th, 2008 at 9:46 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Feb 2006

Posts: 2,467

Reputation: masijade has much to be proud of

Solved Threads: 267

masijade

Offline

Nearly a Posting Maven

Re: Add month in date

May 27th, 2008

Use Calendar and its add method.

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan

•

Join Date: Nov 2004

Posts: 6,143

Reputation: jwenting is just really nice

Solved Threads: 212

jwenting

Offline

duckman

Re: Add month in date

May 27th, 2008

but don't do it in a JSP.

As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.

•

Join Date: Dec 2007

Posts: 11

Reputation: shweta797 is an unknown quantity at this point

Solved Threads: 0

shweta797

Offline

Newbie Poster

Re: Add month in date

May 28th, 2008

•

Originally Posted by masijade

Use Calendar and its add method.

Can You specify some code for it

Thanks

•

Join Date: Feb 2006

Posts: 2,467

Reputation: masijade has much to be proud of

Solved Threads: 267

masijade

Offline

Nearly a Posting Maven

Re: Add month in date

May 28th, 2008

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
Calendar c = Calendar.getInstance();
c.setTime(date);
c.add(field, amount);
c.getTime();
Calendar c = Calendar.getInstance();
c.setTime(date);
c.add(field, amount);
c.getTime();

Read the API docs, they contain more than enough information for this sort of thing.

As mentioned, however, you should not be doing this in a JSP. Scriptlets have no place anymore in a JSP. They are only still allowed so as not to break old JSP (i.e. backwards compatability) but you should not be creating any new scriptlets. Use a Bean.