Convert String to Date Issue

[Ragupathirajan Venkatesan]

Dear All,

I am trying to convert the string to date by using the below logic. My actual requiremt is to get the date which five days before than today. Please suggest. Thanks advance.

   Calendar ca1 = Calendar.getInstance();

         ca1.add(Calendar.MONTH, 1);
        int iDay=ca1.get(Calendar.DATE); 
        int iMonth=ca1.get(Calendar.MONTH); // In Current date Add 1 in month
        int iYear=ca1.get(Calendar.YEAR);
        
        String date=iDay+"-"+iMonth+"-"+iYear;
        System.out.println("date: "+date);
        
        SimpleDateFormat  sdf=new SimpleDateFormat("dd-mm-yyyy");
        System.out.println("todayDate: "+sdf.parse(date));

       
       I am getting the value for todayDate as 
              todayDate: Sat Jan 22 00:06:00 GMT+05:30 2011
      It should be Jun instead Jan. Please advice.

       

[Pramod P Deore]

use

SimpleDateFormat  sdf=new SimpleDateFormat("dd-MM-yyyy");  

instead of

SimpleDateFormat  sdf=new SimpleDateFormat("dd-mm-yyyy");  

[Seetharaman Venkatasamy]

mm-represents minutes
MM-represents month

[Ragupathirajan Venkatesan]

Thanks a lot Seetharaman. It works for me.

[Ragupathirajan Venkatesan]

Hi Seetharaman,

I am trying to update the existing excel sheet using java. Means need to check the no of rows in the existing sheet, if it is 10 i need add the data into 11th row. Please suggest me any link or code to solve this problem. I can able to insert the any number of rows in one short but if i try to update the existing one.. i could not(no exception it is throwing at the same time no data getting added newly). Thanks in advance.

[Rob Spoor]

Have you already tried Apache POI or JExcelAPI (JXL)?

[Ragupathirajan Venkatesan]

Hi

I have already tried in jxl, please post your comments in jxl or poi, may be my way of trying could be differed from you. Thanks