Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sorry guys, i was trying to edit with my smartphone yesterday and something went wrong =/
Ajay, now i've got another situation. Using your example, sometimes this occurs:
| userid | start_Date | final_Date | flag_delete | audience |
| 35 | 20/06/2013 | 30/06/2013 | N | 0,36666666666667 |
| 35 | 22/07/2013 | 31/07/2013 | N | 0,33333333333333 |
| 35 | 22/07/2013 | 09/11/2013 | N | 3,7 |
| 35 | 02/09/2013 | 01/10/2013 | Y | 1 |
| 35 | 10/11/2013 | 03/12/2013 | N | 0,8 |
Note that the row n2 dates are between the row n3. Assuming that peek() are getting only the previous record, how can i handle that?