-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules