topic Re: ALV date format problem in Application Development and Automation Discussions

ALV date format problem

Former Member — Wed, 13 Aug 2008 14:47:14 GMT

Hi ,

I Created an ALV report in that I am getting the sales order details... and once I get the list I am moving to excel sheet ...

Once I moved to excel sheet by creating the layout , I am getting DAT colums as 00.00.0000 if the cell is empty.. how to avoide this ....

Re: ALV date format problem

Former Member — Wed, 13 Aug 2008 14:49:07 GMT

what needs to be done is before moving to excel sheet, take a Char type for the field and move the date to this char type. If no date move space.

Re: ALV date format problem

Former Member — Wed, 13 Aug 2008 14:49:20 GMT

Try with NO_ZERO = 'X'. for the Date field in the fieldcatalog.

I am not sure of this , Give a try once.

Re: ALV date format problem

Former Member — Wed, 13 Aug 2008 14:52:06 GMT

Initial value for a date field is 00000000 that's why u r getting 00.00.0000 when the field is empty. If u want blank for this then use data type CHAR instead of DAT.