03-03-2009 11:38 AM
Hi.
i am doing the same write statement for both the dates like march 3rd 09 and january 01 2008,but while downloading the file in spreasheet,the style is getting changed.i have tried using left-jiustified and condense keywords still the problem remains same.in the execution of report,both are coming in same style but here you can see that the sttyle is getting chnges.
please suggest what to do in such case.
thanks!
(All ship-tos)Report
3-Mar-09
06:28:42AM
January 01, 2008 to December 31, 2008
03-03-2009 12:00 PM
Hi, Format the cells in Excel sheet.
The problem may not be in WRITE Statement
03-03-2009 11:48 AM
it may be some problem with the format of the cell at whcih it is getting filled..
please check the properties of the cell..
03-03-2009 12:00 PM
Hi, Format the cells in Excel sheet.
The problem may not be in WRITE Statement
03-03-2009 12:03 PM
thanks.
my problem got solved as there was nothing in the write statement.
the format of date was getting changed because in excel,it was purely a date so i made the dot concatenated with it to make it as string.
thnaks!