Skip to Content
avatar image
Former Member

Incorrect Date format in COPY TABLE (Export to Excel)

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded