Following a project I'm developing, I've had a situation I can not solve.
The purpose of this question is to know how to get on a given day the number of requests a school library makes. So far so good, this problem is solved.
Now, I came up with a new idea but it is difficult to solve and is this: I wanted to do the same thing with the above, but through datetimepicker
choose the day and appear through a base search of data to know the requests of that day.
Below I will leave prints of the code I have at the moment and the respective forms.
This is select
used for now:
SELECT Requisição.codRequisicao,
Requisição.dataRequisicao,
Utilizadores.numProcesso,
Utilizadores.nomeUtilizador,
Turma.Ano,
Turma.Turma,
Turma.Curso,
TpUtilizador.Descricao,
TipoServiço.descricaoTpServico
FROM Requisição
INNER JOIN TipoServiço ON Requisição.codTpServico = TipoServiço.codTpServico
INNER JOIN Utilizadores ON Requisição.numProcesso = Utilizadores.numProcesso
INNER JOIN Turma ON Utilizadores.codTurma = Turma.codTurma
INNER JOIN TpUtilizador ON Utilizadores.CodUtilizador = TpUtilizador.CodUtilizador
WHERE (Requisição.dataRequisicao >= CONVERT(date, GETDATE()))
For example, on 06/26/2015 a certain person made a request:
Thisiswheretherequisitionsareregistered: