fetch the last time records from current date

Question

hii friends ...Good Afternoon..

I have a table name as "Recharge" and it has a column recharge_date and Current_bal 

now i want to fetch last data or value from column current_bal of last day.

 

like-

I want the last data or value of yesterday from column current_bal.

How can i do that...