How possible is (Never see it before in C#)

Question

Hello!

I configure my dataset file like this:

SELECT [Date], [Name], [On_duty], [Off_duty], [Early], [Clock_In], [Clock_Out], [Absent], [Department], [Identificação], [NDays], [NDays_1], [Anexo] FROM [1]

where [date] between ? and ? and [name] = ?

and in my button is like this:

this._1TableAdapter.Fill(this.DataSet1._1, dataInicialConsPorNomes.Text, dataFinalConsPorNomes.Text, txtName.Text);

this.reportViewer1.RefreshReport();

Curiosly, the filter starts well from one date to another.
But not as recommended, for example if I filter from 2 of February 2015 to 10 of February of 2015. Its will not filter the 2 february's until 10 february 2015. But he will do from 3 of February to 10 of February 2015 (correct but not really because its missing one day).
Then Now when I ask for example 31st of January 2015 from 10 of February 2015. Its doesnt show nothing (only title without datas).
Which solution please.

Vikram Agrawal · Answer

Hi Israel Whatever Jignesh explained is absolutely right. You can verify it by removing name filter then check with 2nd February and as well as with 31st January. I hope it will give you the correct result set. Thanks

Jignesh Trivedi · Answer

Hi Between is alway return value expression is greater than or equal to the value of expression and less than or equal to the value of end expression. you have also another filter Name . It might possible this condition is not true for 2nd feb.... hope this will help you.

Israel · Answer

Thank you to all to respond to my question. But the error comes from me. When I criate my table in Ms Access I didnt put the date's column Date's Type . I leave it (or forgot) in text's  Type  than to be  Date  type. Now its works. Thanx to all.

Vulpes · Answer

In your original query: SELECT [Date] [Name] [On_duty] [Off_duty] [Early] [Clock_In] [Clock_Out] [Absent] [Department] [Identificação] [NDays] [NDays_1] [Anexo] FROM [1] where [date] between ? and ? and [name] = ? can you show the code where you're setting the three parameters.

Israel · Answer

See what I do to make filter from one day of the last month to the recent (or another month). Even like that its doesnt works (need solution for that please): SELECT [Date] [Name] [On_duty] [Off_duty] [Early] [Clock_In] [Clock_Out] [Absent] [Department] [Identificação] [NDays] [NDays_1] [Anexo] FROM [1] where [date] >= ? and ? and [name] = ?