4
Following a project I’m developing, a situation occurred to me where I can’t solve.
The purpose of this question is to know how to obtain on a given day the number of requests that 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 it is the following: I still wanted to do what I said above, but through the datetimepicker
choose the day and appear through a database search to know if the requests of that day.
Below I will leave prints of the code I have at this time and the respective formats.
This is the 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 the day 26/06/2015 certain person made a request:
This is where the requisitions are registered:
I saw your edition in my reply, your mistake is in the first parentheses before the
CONVERT
remove it in such a way that it matches my answer– Maicon Carraro