-
Dates before 30 days
Friends,
I have this sql statement:
SELECT TblAnalista.NomeDoAnalista, TblEmpresa.NomeDaEmpresa, TblProduto.NomeDoProduto, TblPassosStatus.Passo, Nz([DataReprogramada],[DataProgramada]) AS DataDue, TblPassosStatus.C
FROM ((TblAnalista LEFT JOIN TblEmpresa ON TblAnalista.CodAnalista=TblEmpresa.CodAnalista) LEFT JOIN TblProduto ON TblEmpresa.CodEmpresa=TblProduto.CodEmpresa) LEFT JOIN TblPassosStatus ON TblProduto.CodProduto=TblPassosStatus.CodProduto
WHERE (((Nz([DataReprogramada],[DataProgramada]))<Date()) AND ((TblPassosStatus.DataRealizada) Is Null) AND ((TblProduto.[Ativado])=Yes))
ORDER BY Nz([DataProgramada],[DataReprogramada]);
WHERE I have provided all dates less than today.
For example, How do I select only dates overdue for more than
30 days, ie, all the dates before March 20?
Thank you.
-
-
where table.datefield < today()-30
-
mohanvijay jand BrianMH, thanks for responding.
Sorry, I drew up wrong, I'm trying two criteria.
I'm trying to dates before today between 15 and 30 days.
For example, dates from March 20 until April 5, ie 30 days before until 15 days before today.
Thank you.
-
where (table.datefield < today() -15 and table.datefield > today()-30)
-
How do I put the sql, so I tried but did not work. Syntax error (missing operator).
SELECT TblAnalista.NomeDoAnalista, TblEmpresa.NomeDaEmpresa, TblProduto.NomeDoProduto, TblPassosStatus.Passo, Nz([DataReprogramada],[DataProgramada]) AS DataDue, TblPassosStatus.C
FROM ((TblAnalista LEFT JOIN TblEmpresa ON TblAnalista.CodAnalista=TblEmpresa.CodAnalista) LEFT JOIN TblProduto ON TblEmpresa.CodEmpresa=TblProduto.CodEmpresa) LEFT JOIN TblPassosStatus ON TblProduto.CodProduto=TblPassosStatus.CodProduto
WHERE (((Nz([DataReprogramada],[DataProgramada]))<Date()-15 AND ((Nz([DataReprogramada],[DataProgramada])) > Date()-30) AND ((TblPassosStatus.DataRealizada) Is Null) AND ((TblProduto.[Ativado])=Yes))
ORDER BY Nz([DataProgramada],[DataReprogramada]);
-
BrianMH and mohanvijay, thank you for help. I got using Between.
WHERE Nz ([DataReprogramada], [DataProgramada]) Between Date () - 30 And Date () - 15 AND TblPassosStatus.DataRealizada Is Null AND TblProduto. [Enabled] = Yes
Again, thank you.