I have a spreadsheet with a date 1/1/2012 in one column and a time 8:00 AM in another column. I need to concatenate these into one cell with the yyyy-MM-ddThh:mm:ssZ so I can import these event records. Every time I try it I get a number result such as 14245.3333333 and no matter what I do I can't get it into the right format.
Any ideas?!?! PLEASE AND THANK YOU!
3 respuestas
Here's a variation on Jeff's formula that should work. Note how you can use your 3-letter US timezone instead of "Zulu" GMT if you wish. In this example, I'm using Pacific Daylight Time.
=CONCATENATE(TEXT(theDateFieldCell, "yyyy-mm-dd"), "T", TEXT(theTimeFieldCell, "hh:mm:ss:SSS"), "PDT")
See this link for more details about the time format.
http://raydehler.com/cloud/clod/data-loader-and-the-datetime-data-type.html
