I have issues using datenum function because of a different date format on excel, how can I modify my dates in matlab and then run the function?n
1 view (last 30 days)
Steven Lord on 30 Aug 2022
Don't use serial date numbers and datenum. Use datetime instead.
s = "12:34:56, 30 08 2022"
fmt = "HH:mm:SS, dd MM yyyy";
dt = datetime(s, InputFormat=fmt) % Use the default Format
dt2 = dt; dt2.Format = fmt % or you can use the original format
More Answers (1)
dpb on 30 Aug 2022
You can either use an import options object from detectImportOptions in which you set the format for the date format or let it read it as cellstr or string and convert.
Presuming you've done the latter to get the posted code -- it would have been more helpful to have seen that as well as the short example section of the actual input file...
EX.Time=EX.DateTime-EX.DateTime(1); % convert to duration for use in analysis
You may also find it convenient to use seconds(EX.Time) as the analysis time variable for timeseries analyses instead of the duration class, depending upon just what functions you're planning on using; not all of the Signal Processing TB has been made datetime/duration aware.