You essentially have to use text to columns breaking the string into year, month, day, hours and minutes and re-combining. You couldn't just create the datetime; you had to create the date first using a YYYY-MM-DD string and then datetimeadd hours and minutes.