Breadcrumbs

[Dummy1912]

Hello,

can anyone help me out
i want to show the date ordering? from small value to higher value

but i get it like this image :(

i used:

Code: Select all

Dim empls As SQLiteDataReader = DataBase.executeQuery("SELECT " & attributes & " FROM transactions " & fromClause & " WHERE " & whereClause & " ORDER BY transactions.sdate ASC;")

sdate looks like: 3/6/2017 ' month day year


please

Thanks

[CodenStuff]

Are you storing it as a date/time or string value?

You should really be saving dates and times as a date/time stamp.

[Dummy1912]

Hello,

just as a string.

and why as a date time value?
is there a reason for.

[CodenStuff]

Just storing it as a date or date/time stamp is easier to sort. It would make your life a lot easier when pulling information from the database

This may help you with information on storing dates: https://www.sqlite.org/lang_datefunc.html