Skip to Content
0
Sep 25, 2016 at 01:05 PM

Use Copy Table at Query Listing to Excel - Date column is copied as General instead of Date format

38 Views

Hi All,

I have created a simple query in SAP B1 v9.1 Client (Hana Version).

SELECT T0."CardCode", T0."CardName", T0."DocNum", T0."DocDate", T0."DocTotal"

FROM ORDR T0

ORDER BY 1,3

I used Copy Table of the query result and Paste it to Excel.

At Excel, the Date column (DocDate) is considered as a General Data Type, not a Date Data Type.

I am unable to do formatted on this Date Column in Excel.

Any one has a way to resolve this?

Regards

Jessie