Log in

View Full Version : Dates before 30 days


fabio2012
04-19-2012, 01:41 PM
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.
mohanvijay
04-19-2012, 09:36 PM
Try DateDiff Function
BrianMH
04-19-2012, 11:49 PM
where table.datefield < today()-30
fabio2012
04-20-2012, 03:49 AM
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.
BrianMH
04-20-2012, 05:18 AM
where (table.datefield < today() -15 and table.datefield > today()-30)
fabio2012
04-20-2012, 09:56 AM
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]);
fabio2012
04-20-2012, 11:32 AM
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.