WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Date format changed when I imported a CSV table (4 posts)

  1. LindaEve
    Member
    Posted 1 year ago #

    Hi - love this plugin, it is brilliant! But here's a strange issue and I have not seen it on the forum. I imported a CSV file and one column contained dates in the following format: 01/22/2010. But the imported table in TablePress showed the dates as 2010-01-22, which is great for sorting, but not how I want the dates to display. Any idea how to fix? Thanks so much!

    http://wordpress.org/extend/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Linda,

    thanks for the post, and sorry for the trouble.

    Now, TablePress does not (and can not) alter the date format of cells. TablePress imports the data exactly as it is in the CSV file. Therefore, my assumption is that this already happened when saving the table to a CSV file in Excel.
    To verify, please open the CSV file in a text editor, like Notepad, and check the format of the dates there. They will show as 2010-01-22 there.

    Unfortunately, I don't know how you can tell Excel to export them as 01/22/2010, but there could be a setting somewhere.

    Regards,
    Tobias

  3. LindaEve
    Member
    Posted 1 year ago #

    Thanks Tobias. I think Excel imposed the change. I seem to have it worked out now.
    Linda

  4. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Linda,

    great! I hope you can find a solution that doesn't cause too much extra work.
    There's nothing that I can change about this in TablePress, so sorting this out in Excel is the way to go.

    Best wishes,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic