I need to sort the records in a dataset based on date in ascending order. If there are three dates namely 31.1.1998, 2.12.1997,3.6.2014 then output should have 2.12.1997,31.1.1998,3.6.2014
I have used the sort card:
Code: Select all
SORT FIELDS =(60,10,UFF,A)
But the records are not getting sorted properly. Can you guys please suggest how to solve it.