Hi to everyone.
I have created jsp report in that date column is there where am showing the date format like this (02-01-2012)
<% String Rcheckdate=""; SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Rcheckdate=df.format(rs.getDate("tr_dt")); %> <td align='center'><%=Rcheckdate%></td>
In report i have given the excel button from there am exporting the data to excel sheet.. but while am exporting the data to excel sheet the date format is changing... where two format is showing in sheet
02-01-2012 (I want in this format in whole sheet not above)
Can anyone suggest me why its changing.
Thanks in advance.