Hi all ,
i am having the dates like 5/29/2018 in array ( month / date / year ) [ reading from the access database ]
i need to sort the dates in a correct order . used sort array option , but not getting in a right order. pls, see attached image here .
any other options?
Its always good to share code(VI)/Code snippet, Nothing can be understood by attaching image of FP.
Try this, May be others can suggest easy conversion.
They are ordered as strings. You need to convert strings to Timestamps before sorting, using Scan From String with format string %<%m/%d/%y>T
My solution is similar to Paul's. It just avoids the conversion back into a string.