how to sort cells by date?

2 views (last 30 days)
Amr Hashem
Amr Hashem on 24 Aug 2015
Commented: Amr Hashem on 24 Aug 2015
i have a column of dates DD\MM\YYYY, i want to sort them by date .
i try:
sort(A);
but it sorts them by days
how i can do this?
  2 Comments
Walter Roberson
Walter Roberson on 24 Aug 2015
Is 11\5\2007 before or after 11/5/2007 ?
Amr Hashem
Amr Hashem on 24 Aug 2015
Are you joking? what do you mean?

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 24 Aug 2015
[~, order] = datenum(A(:,1));
sortedA = A(order,:);
  3 Comments
Walter Roberson
Walter Roberson on 24 Aug 2015
Edited: Walter Roberson on 24 Aug 2015
[~, order] = sort(datenum(A(:,1)));
sortedA = A(order,:);
Amr Hashem
Amr Hashem on 24 Aug 2015
Thanks... it works, but it didn't sort all of them.
as I discovered that some of dates written in the form "dd/mm/yyyy" and others "mm/dd/yyyy".
so it seems that I have to convert them first to one form.

Sign in to comment.

Categories

Find more on Shifting and Sorting Matrices in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!