General information
Category:
Coding, syntax & commands
> Also you have not specified what results should be returned where you have > 4 (or more) consecutive dates all with .T. The code above will return the > first-date, first-date + 1, and so on.
tried your suggestion but it doesn't seem to give me the results i need.. like there are records selected that only have 1 tfamt = .T. in a week..
i need to select records with tfamt = .T. in 3 CONSECUTIVE days.. say,
12/01/2003 .T.
12/02/2003 .T.
12/03/2003 .T.
12/04/2003 .F.
12/05/2003 .F.
12/06/2003 .F.
12/07/2003 .F.
12/08/2003 .T.
12/09/2003 .T.
12/10/2003 .F.
12/11/2003 .F.
12/12/2003 .T.
12/13/2003 .T.
12/14/2003 .T.
12/15/2003 .T.
i should a result of
12/01/2003
12/02/2003
12/03/2003
12/12/2003
12/12/2003
12/14/2003
any more help?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only