I have the following table:

CREATE TABLE votehistory ( voterId integer NOT null, county TEXT NOT NULL, electionDate DATE NOT NULL, electionType TEXT NOT NULL, historyCode TEXT NOT NULL );

The data looks like this:

206869614 ROC 01/14/2014 PRI Y
206864773 ROC 01/14/2014 PRI B
206852342 ROC 01/14/2014 PRI A

The question I have is that the DATE field looks correct, but behaves as if it is a text field for ORDER BY. I am pretty sure that the data loaded was in exactly that format (MM/DD/YYYY). To get it to sort I had to massage it this way: substr(B.electionDate,7,4)||"-"||substr(B.electionDate,1,2)||"-"||substr(B.electionDate,4,2) as electionDate,

What am I missing? If sqlite understands 'electionDate' is a DATE, can it really not order it?

OOPS! My bad... I will look at doing an update to the ISO format..