ALV date format problem

[Former Member]

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 ....

[Former Member]

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.

[Former Member]

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

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

[Former Member]

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.