Exporting entries to Excel 2007 the date format is not correct

Home Forums Quform WordPress Exporting entries to Excel 2007 the date format is not correct

This topic is: resolved
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #30800
    mmoraco
    Participant

    When I export the entries to Excel 2007 and select the “All option” . The Date and Las modified should be the dates that wordpress stores. But when I open the excel the date is an integer and not the date. And when I change the cell type to date, it is also incorrect ¿Why? How do I solve it?

    My Qform configuration is Locale: Spain ,
    RTL support Autodetect,
    Date & time format (JS) dd/MM/yyyy hh ss
    Date & time format (PHP) d/m/Y H i

    I attach screenshots
    Thanks.

    Attachments:
    You must be logged in to view attached files.
    #30809
    Ally
    Support Staff

    You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

    #30810
    Ally
    Support Staff

    You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

    #30854
    mmoraco
    Participant

    Thank you Ali. It works correctly for me

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
Be inspired. © 2020 ThemeCatcher Ltd. 20-22 Wenlock Road, London, England, N1 7GU | Company No. 08120384 | Built with React | Privacy Policy