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?