5 Replies Latest reply: Jan 7, 2015 2:26 AM by Ebrahim Seedat RSS

    Sorting to preserve a chronological order

      I loaded an .xls file into QV. One of the fields contains dates in the format DD/MM/YYYY which must be sorted in QV so that, for example, January entries appear on the top-most row whereas December entries appear at the bottom. However, after sorting, March entries appear between July and August entries. Most of the field nevertheless has been properly sorted. Please advise on how to sort every entry in the chronological order described above.