what is my problem in using datevec?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
cd('C:\Users\Kwom\Desktop');
% I loaded my folder
file=xlsread('Week02_climate_data_analysis.xls');
% I loaded my Excel file in my folder. - 14244x5 double
% in the excel file, the column is date (ex. 19730101) the row is temperature, humidity...etc.
% my purpose is to separate the spring(March~May), summer(June~August), fall(September~November), winter(December~February) by using 'datevec' in Excel's column.
% So, I made these ones...
date=num2str(file(:,1));
dateformat='yyyy,mm,dd';
datevec(date,dateformat)
However, it has a error... I don't know what is a problem...
What should I do...?
1 commentaire
Réponses (1)
Saurabh Gupta
le 21 Sep 2016
Hello Ryoung,
Based on your description, it seems that your date values are in the format 'yyyymmdd' (ex. 19730101), but you are using the date format as ‘yyyy,mm,dd’ for the datevec function. Your ‘dateformat’ string should match the date format in your ‘date’ string (i.e. the format of the date values in your source file).
0 commentaires
Voir également
Catégories
En savoir plus sur Dates and Time dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!