Error using strfind Conversion to double from table is not possible.

I have a table and I extracted one value from the table and it is

dataTimeColumn(1,1) = 2023-07-24T16:15:54.200

And I tried to find T in this by using strfind like this.

temp2 = strfind(dataTimeColumn(1,1),'T')

and when I run I get the error

Error using strfind

Conversion to double from table is not possible.

Why is that and how can I solve it. Thank you.

Answer 1

[Star Strider]

It is apparently not an actual datetime variable (array). Instead of searching for the ‘T’ occurrences, convert it to datetime instead —

dataTimeColumn(1,1) = datetime('2023-07-24T16:15:54.200', 'InputFormat','yyyy-MM-dd''T''HH:mm:ss.SSS', 'Format','yyyy-MM-dd HH:mm:ss.SSS')

dataTimeColumn = datetime
   2023-07-24 16:15:54.200

.

Answer 2

[Walter Roberson]

temp2 = strfind(dataTimeColumn{1,1},'T')

[Govind Sankar Madhavan Pillai Ramachandran Nair]

now it says conversion from double to datetime is not possible