MATLAB: Char array comparison

char comparision

I have a large char array and these are dates so the array has elements as: 20070801 20070802 20070803 etc.

This array shows up as 100×8 in the workspace. I want to get all the dates which are less than 20070915. How do I use the 'find' function to achieve this or any other straight forward method?

Best Answer

 a=['20070801';'20070802';'20070803']; %some date values
 b=20070802; %value to compare
 a(find(str2num(a)<b),:) %date values older than the compared value

Related Solutions

MATLAB: Convert SQL dates to MATLAB datenums

Import data in the form of a MATLAB dataset.

setdbprefs('DataReturnFormat', 'dataset');

Run query and assign data to output variable.

result = runsqlscript(connection, 'myQueryFile.sql');
out = result.Data;

Then use the column name that contains your dates as follows.

out.DateOfPeriod = datenum(out.DateOfPeriod, 'yyyy-mm-dd'); % convert from readable date to datenum
out.DateOfPeriod = datestr(out.DateOfPeriod); % convert back to readable date

MATLAB: Open and read monthly dataseries with the filename ‘yyyymmdd’

Try this is code:

StartDate = 20100502;
EndDate = 20160201;
v = datevec([sprintf('%d',StartDate);sprintf('%d',EndDate)],'yyyymmdd');
[y,m,d] =datevec(datenum(v(1,1),v(1,2)+(0:diff(v(:,1:2))*[12;1])',1));
out = [y,m,d];

Best Answer

Related Solutions

MATLAB: Convert SQL dates to MATLAB datenums

MATLAB: Open and read monthly dataseries with the filename ‘yyyymmdd’

Related Question