Incorrect Date format in COPY TABLE (Export to Excel)

[former_member267495]

Dear Experts,

We are trying to export the inventory audit report to Excel by using COPY TABLE and paste in excel. while doing this , some date formats are coming like 20/12/2017 and few dates are coming like 20-12-17. How to avoid this ?

Thanks in advance.

Sen.

[Former Member]

Hi,

please try to edit the format of the column in Excel before pasting.