android - Fetching previous entry if particular date value doesn't exist -

I want to get the value for the last entry if entry is not present on that date

example For: -

What is currently happening, if I change the last date and the record is not present, then I see today's record or that already I have been shown but I do not want to enter the last entry when the record is not present.

One more example ..

DATE | Target 17 320 16. 420 13 300

If the user is pressing the previous button and it is at 16 then the user should get 15 dates at 15, because no value exists for 15.

Use WHERE to ignore all rows with a later date, then the row is the most Take with the bigger balance date:

  Choose from my time SELECT * date & lt; = * The_value * ORDER date DESC LIMIT 1