Convert data table to datetime

I have data shown in the image.

I want to convert the second row into a datetime vector, but InputFormat doesn't work.

It's a number, e.g. 201401010000 meaning jan 1st 2014 00:00.

I tried datetime( BLA,'InputFormat','yyyyMMddHHmm')

Answer 1

[Adam Danz]

> It's a number, e.g. 201401010000 meaning jan 1st 2014 00:00.

x = 201401010000;
dt =  datetime(string(x),'InputFormat','yyyyMMddHHmm')

dt = datetime
   01-Jan-2014

The 'format' property specifies the output format.

x can be a column of values.

[Raphael Willi]

Yes that works. But I have a table as input. I would like to e.g. convert it to a timetable

[Adam Danz]

> I want to convert the second row into a datetime vector

> I would like to e.g. convert it to a timetable

Those are two very different questions.

I've updated my answer. After converting the column to datetime use

TT = table2timetable(T,'RowTimes',timeVarName)

[Raphael Willi]

Aha, I got it now thanks. I did it with

 TT = table2timetable(data(:,3),'RowTimes',datetime(string(data{:,2}),'InputFormat','yyyyMMddHHmm'));