25 Dez 2020 17:44
select * from Tabela where year(data) = 2020 and month(data) = 12
25 Dez 2020 18:25
tchadrack escreveu:Existe alguma forma ou sou obrigado
a percorrer a tabela testando cada registro?
INDEX ON DtoS (data) TO idxData
USE tabela SHARED NEW INDEX idxData
DbSeek ( "202012", .T. ) // Soft seek
DO WHILE .NOT. Eof() .AND. Left (DtoS(data), 6) == "202012"
// comandos...
tabela->( DbSkip () )
ENDDO
tabela->(DbCloseArea ())
RETURN
25 Dez 2020 22:05
SET SCOPE TO "202012"
GOTO TOP
DO WHILE ! Eof()
SKIP
ENDDO
25 Dez 2020 22:42
15 Jan 2021 09:09
set filter to Year(data)=2020 and month(data)=12
27 Jan 2021 08:20