Closeing Balance to Opening Balance

Question

i want to say that i have a major problem in asp.net using sql 2005 i want oftoday closing Balance  opening of tomorrow or next month  is it possible 
                                                                            thanks
                                                                             Er. Praveen Sharma