NI Community
Help
cancel
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

sort date

willcan
Member
Member
‎09-20-2018 01:54 AM
‎09-20-2018 01:54 AM

sort date

Message contains an attachment

 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?

Labels:
0 Kudos
Reply
6 REPLIES 6
PalanivelThiruvenkadam
Active Participant Active Participant
Active Participant
‎09-20-2018 02:00 AM
‎09-20-2018 02:00 AM

Re: sort date

Its always good to share code(VI)/Code snippet, Nothing can be understood by attaching image of FP.

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Reply
PalanivelThiruvenkadam
Active Participant Active Participant
Active Participant
‎09-20-2018 02:22 AM
‎09-20-2018 02:22 AM

Re: sort date

Message contains an image

 

DateSorting.png 

Try this, May be others can suggest easy conversion.

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
Reply
pincpanter
Trusted Enthusiast
Trusted Enthusiast
‎09-20-2018 02:26 AM
‎09-20-2018 02:26 AM

Rif.: sort date

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

Paolo
-------------------
LV 7.1, 2011, 2017, 2019, 2021
0 Kudos
Reply
paul_cardinale
Trusted Enthusiast
Trusted Enthusiast
‎09-20-2018 08:34 AM
‎09-20-2018 08:34 AM

Re: sort date

Message contains an image

sd.png

"If you weren't supposed to push it, it wouldn't be a button."
0 Kudos
Reply
cstorey
Active Participant
Active Participant
‎09-20-2018 10:35 AM
‎09-20-2018 10:35 AM

Re: sort date

Message contains a hyperlink

Easiest way if you have control is to start with dates in ISO 8601 format.  Then you can just remove the "/" and sort as numbers.

 

Reference: https://xkcd.com/1179/

0 Kudos
Reply
crossrulz
Knight of NI Knight of NI
Knight of NI
‎09-20-2018 12:51 PM
‎09-20-2018 12:51 PM

Re: sort date

Message contains an image Message contains an attachment

My solution is similar to Paul's.  It just avoids the conversion back into a string.


There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
Reply