Sqlite MultiDate?
Posted: Fri Sep 29, 2017 5:56 pm
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/
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 all
Thanks Dim 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 & ";")