increasing the date in java as whole

[rammie singh]

Hi all,

How can we increase the date in java as whole. I mean to say that suppose my current date is 30/09/2011 then after increasing the date by 1 it should directly give 1/10/2011 not 31/09/2011 or if i increase by 2 it should give 02/10/2011 not 01/09/2011.
what i am trying is below. Is there any functions where month or year are automatically taken care off after increasing.

cell = row.getCell(colIndex-3);
SimpleDateFormat sdf = new SimpleDateFormat("dd/mm/yy");
DataFormatter dformatter = new DataFormatter(Locale.UK);
String date = dformatter.formatCellValue(cell);
System.out.println("date is .."+date); // [b]here my date in exel cell is 16/09/2011[/b]

Calendar c = Calendar.getInstance();
c.setTime(sdf.parse(date));
c.add(Calendar.DATE, 16);
date = sdf.format(c.getTime());
System.out.println("new date is .."+date); // [b]here after increment it gives 01/09/2011 and not 02/10/2011[/b]

can any body please help me.

[Matthew Brown]

First thing you need to do is get your format corrected:

- For day of the month, you need to use "MM", not "mm" ("mm" is for minute)
- If you're parsing a four-digit year, use "yyyy"

Fix those, and see if the problem still occurs.

[Zandis Murāns]

Add Calendar.DAY_OF_MONTH instead of Calendar.DATE

[Matthew Brown]

Zandis Murāns wrote:Add Calendar.DAY_OF_MONTH instead of Calendar.DATE

That won't make any difference. Look up Calendar.DATE in the docs and you get:

This is a synonym for DAY_OF_MONTH.

[Rob Spoor]

The problem is in your formatter. "mm" means minutes; you need "MM" for months. Beaten to it when I was testing.

[rammie singh]

Thanks everybody.

The problem indeed was in selecting the format. i tried ("dd/MM/yyyy") and it is working.