Skip to Content
0

Incorrect Date format in COPY TABLE (Export to Excel)

Apr 10 at 08:56 AM

30

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 13 at 08:48 AM
0

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded