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

[jessie_ng2]

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

[Former Member]

Dear Jessie

As I am user, I will amend the content that can show with date data type.

Would you mind to show what information do you paste it to Excel?

Regards

Edmund