Problems using "datetime" cont.

Hi,

Having solved problems with getting the current date from a structure into a table (thank you Adam). Using "datetime" still does not seem to be carrying out the conversion. Any thoughts?

Kind regards,

Andy

table

                  Dates              
    _________________________________

    "12/24/2008 9:59:47 AM.786743640"
    
  %Current file format{'12/24/2008 9:59:47 AM.786743640'}
  
  %Fileformat to convert to = data-20130325T004512Z.mat
    
date=cell2mat(dateName);
data=cell2mat(timeDom);

N = date
T = table(string(N), 'VariableNames', {'Dates'})

dt = datetime('T.Dates','Format','yyyyMMdd''T''HHmmss''Z')

% TODO: Save files

   save(data, '-append', '-struct', 'dt');
   
Error using datetime (line 640)
Unable to convert 'T.Dates' to datetime using the format 'yyyyMMdd'T'HHmmss'Z'.

Error in extractor (line 20)
dt = datetime('T.Dates','Format','yyyyMMdd''T''HHmmss''Z')

Answer 1

[Stephen23]

You should probably specify the input format to match the provided string:

S = "12/24/2008 9:59:47 AM.786743640";
D = datetime(S, 'InputFormat','MM/dd/yyyy h:m:s a.SSSSSSSSS')

D = datetime
   24-Dec-2008 09:59:47

D.Format = 'yyyyMMdd''T''HHmmss''Z'''

D = datetime
   20081224T095947Z

You also need to refer to the table, not define a literal character vector:

datetime( T.Dates ,...) % correct way to refert to table T.
datetime('T.Dates',...) % defines a character vector, does not help you.

[Andy Wileman]

Success!!! Thank you Stephen. I guess it makes sense that you need to specify a format first, else Matlab doesn't know what its converting.

Once again, thank you to everyone who helped.

[Stephen23]

@Andy Wileman: note that I assumed that the trailing decimal fraction are fractional seconds. If they represent some other data, then you will need to make the required changes.

[Andy Wileman]

I think they are trailing seconds, as the data is from data aquisition. Once again, thanks.