Copyright Codenstuff.com 2017
YOU NEED TO BE LOGGED IN TO USE THIS FEATURE


Register
Credits
0
Reputation
0
Sqlite MultiDate?
If you need help with a project or need to know how to do something specific in VB.NET then please ask your questions in here.
Forum rules
Please LOCK your topics once you have found the solution to your question so we know you no longer require help with your query.


User avatar
Sqlite MultiDate?
Sqlite MultiDate?
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 all
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 & ";")


Thanks :)

User avatar
Re: Sqlite MultiDate?
Re: Sqlite MultiDate?
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

User avatar
Re: Sqlite MultiDate?
Re: Sqlite MultiDate?
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";"

Welcome to CodenStuff.com Learn Code, Love Code. Thank you for being a member of the community.
User avatar
Re: Sqlite MultiDate?
Re: Sqlite MultiDate?
Hi Codenstuff,

Problem solved :D

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




Online now

Users viewing this forum: No registered users and 1 browsing

cron