calculate date-field with python

Question

Hi. I have a string-field (called 'unsplit') which contains concatenated values from other fields separated by a comma (example: 24.07.2010,street,...). I want to split/extract each commaseparated value and calculate it to a new field. I am using the field calculator and a pythonexpression. This expression works fine to calculate the value 'street' to a string-field: '!unsplit!.split(',')[1]
However, i can't calculate the value 24.07.2010 to a date-field using this expression: '!unsplit!.split(',')[0]
The error message is: <type 'exceptions.SyntaxError'>:EOL while scanning string literal.
What is wrong?

MathewCoyle · Accepted Answer

You'll need to make it a date object instead of a string I believe. Something like this maybe. (untested)datetime.datetime.strptime('!unsplit!.split(',')[0], "%d.%m.%Y")