AnsweredAssumed Answered

Format for Importing a DateTime field value from CSV

Question asked by 9a986ec2e3575bbbdb90f750a155eb6a97678792 on Nov 27, 2014
Latest reply on Dec 24, 2015 by Takehiro Monday
I've imported a csv file containing DateTime field formatted as YYYY-MM-DD hh:mm am/pm however it seems that the Marketo server is trying to auto-adjust the time on import to match the Account locale / timezone (EST Sydney) but messing it up in the process. I can get it to import the correct time if I manually update all the times in the spreadsheet (a timeconsuming process) to add +9 hours to the time, but then this throws out the date on import (e.g. if I want to import 4th August 2014 at 13:33, I have to format it as 2014-08-04 22:33 PM to get the time to import as 1:33 PM but then it throws the date out to 5th August in the process). 

This is killing my soul. All suggestions are welcomed :)