Forum Post : Format for startDate field???
Up one levelWhat is the format for importing a date into the startDate field for non-GMT+0 time zones?
This is what I am using, but I am running into timezone problems:
2007-02-21 17:30:00
for 5:30 PM on February 21, 2007.
When I look in the portal catalog at this object, it says the start date is
2007/02/21 17:30:00 GMT+0
The time zone for my zope installation is US/Mountain (GMT-7, no daylight savings). I have the TZ environment variable set to "US/Mountain" in my
runzope script. When I manually add an event to the site, the times are correct.
The problem I am running into is that 2007/02/21 17:30:00 GMT+0 translates to 2007/02/21 1030:00 US/Mountain, so the event shows up in the calendar at
10:30 am on 2/21, and not 5:30 pm.
I tried to specify the time zone for the startDate, but the parser does not pick it up. For example, I tried the following:
2007-02-21 17:30:00 GMT-7
and
2007-02-21 17:30:00 US/Mountain
but the output of the ArchCSV displays
[09:21.54]: Starting import...
Processing Field Data:
[progress:1 out of 72 (1.39 %)] imported: imported.2007-02-21.092155
with dict:{'startDate': '2007-02-21 17:30:00',
so the time zone info is ignored.
How do I get ArcheCSV to correctly interpret the time for my imported events?
Thanks!