Date fields output as a time

  • Resolved srower

    (@srower)


    5 years, 1 month ago

    All of my date fields on an exported Excel file (order date, refund date, etc.) are formatting as ##:## (like 15:52) instead of as an actual date (like 2/2/2020). Once I’m in Excel and format the column as a date, it looks correctly but I’m wondering if there is a way to force that formatting in the initial export file?
    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author algol.plus

    (@algolplus)

    Hello

    Is “format numbers” on , in section “Misc Settings” ?

    Thread Starter srower

    (@srower)

    Thank you for the quick response. I tried it both ways; with “format numbers” checked and unchecked and the result was the same. Today’s date came out as 15:52 until I formatted the column to date format in Excel.

    Plugin Author algol.plus

    (@algolplus)

    Hello

    Could you submit wrongly formatted file to helpdesk ?

    Plugin Author algol.plus

    (@algolplus)

    For whom having same problem.

    Please, don’t set Date = “-” in section “Format”

    • This reply was modified 5 years, 1 month ago by algol.plus.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Date fields output as a time’ is closed to new replies.