Date format

Date format

Hello,

I'm importing a CSV, and all works fine except that i cannot get the datetime format right!

My datetime field values look like the following:

2012-03-28T00:00:00Z   and   2012-03-28T16:11:36Z

Could anyone advise what date format template I might be able to use to import that as a date field? I've tried yyyy-MM-ddThh:mm:ssZ and similar, and the preview looks good but on selecting "ok" i get the error "Invalid date format string found.".

Any help would be appreciated.

Thanks.