Home Forums Support Invoice import – incorrect date format

This topic contains 6 replies, has 2 voices, and was last updated by  Hillel Coren 1 month, 2 weeks ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #23644

    zarkovbill
    Participant

    Self hosting 4.5.17

    I am importing historical invoices from another system via csv file and have a strange issue. My configured date format on the system is dd/mm/yyyy and new invoices created online show that correctly and, when exported to csv show as that.

    I just loaded an invoice dated 09/01/2017 and it loaded to the system as 01/09/2017 – an invoice dated 24/01/2017 loaded with today’s date 20/02/2020 presumably because month 24 would be treated as an error.

    I amended the dates in the loader file to be mm/dd/yyyy and they loaded correctly as dd/mm/yyyy.

    Is there a flag or config item I have missed?

    #23645

    Hillel Coren
    Keymaster

    If you’re importing data YYYY-MM-DD is the best format to use

    #23646

    Hillel Coren
    Keymaster

    Please only post to one place

    #23647

    zarkovbill
    Participant

    Thank you for responding, I will test with that format.

    Apologies for the dual post – which location is most appropriate to use?

    Mike

    #23648

    Hillel Coren
    Keymaster

    Feel free to choose any (GitHub, support forum, email, Slack) but it’s easier for us if you just pick one, we’re the same developers answering in all places

    #23649

    zarkovbill
    Participant

    Great! – Invoices loaded correctly now, many thanks.

    Mike

    CLOSED

    #23650

    Hillel Coren
    Keymaster

    Awesome, glad to hear it!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Posted in: