Page 1 of 1
Sqlite MultiDate?
Posted: Fri Sep 29, 2017 5:56 pm
by Dummy1912
Hello,
i like to show the start date till end date
but it only shows all from 10/1/2017 and 10/12/2017 and not between it :(
i like to show from 10/1/2017 till end 10/12/2017
so also everything between /1/ till end /12/
Code: Select allDim whereClause As String = "transactions.setdate BETWEEN '10/1/2017' AND '10/12/2017'"
Dim tblFields As SQLiteDataReader = DataBase.executeQuery("SELECT " & attributes & " FROM transactions " & fromClause & " WHERE " & whereClause & ";")
Thanks
Re: Sqlite MultiDate?
Posted: Sun Oct 01, 2017 10:16 am
by Dummy1912
Wellllll
it even seems when you have the wrong date display in your own db
you can't even show it properly
so my db has now yyyy-MM-dd and still don't show all my data
it only shows from the date i added in the between
so it only show the dates from 2017-10-01 and 2017-10-12
why not all till 2017-10-12 ?
Anyone please
Re: Sqlite MultiDate?
Posted: Sun Oct 01, 2017 10:38 am
by CodenStuff
Rough but have you tried it like:
Code: Select all Dim tblFields As SQLiteDataReader = DataBase.executeQuery("SELECT " & attributes & " FROM transactions " & fromClause & " WHERE date BETWEEN" & "10/1/2017" & " AND " & "10/12/2017" &" ;")
Formula should work like:
Code: Select all"SELECT thisdata FROM yourtable WHERE date BETWEEN "2017-10-1" AND "2017-10-12";"
Re: Sqlite MultiDate?
Posted: Sun Oct 01, 2017 10:42 am
by Dummy1912
Hi Codenstuff,
Problem solved
it has with my db i had to set all my dates to yyyy-MM-dd and then search for 2017-10-01 and 2017-10-12 and works like a charm
Thanks