Forums

[resolved] [Plugin: GigPress] Wrong Time-of-Day! (3 posts)

  1. devonsproule
    Member
    Posted 2 years ago #

    I'm a very excited new user of WordPress and the plugin GigPress.

    So far, I've had great success uploading gigs with a CSV file that I create in Numbers '08 on my MacBook.

    except...

    My times-of-day are being switched whey they're uploaded. All my AMs become PMs, and vice versa.

    Here's something that may or may not be part of the problem.

    Even though each cell reads 10:30 PM (for example), when I click twice on the cell, it expands and reads 2/11/2010 10:30:00 PM (today's date). This may be completely unrelated.

    Thanks for any advice!

  2. mrherbivore
    Member
    Posted 2 years ago #

    You'll need to look at the exported CSV file to see what's happening (in a text editor, not in Numbers). The time field needs to be in the format 00:00:00, using 24-hour time.

    Numbers probably displays the date in a formatted fashion, but what's important is the actual raw data is exports when you save as CSV.

  3. devonsproule
    Member
    Posted 2 years ago #

    Yes! Yes! That worked. Thanks a million, Mr Herbivore.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags