Page 1 of 1

Dispaly Today Closing bal as tomarrows opening bal

Posted: Sat Mar 08, 2008 2:39 pm
by keerti_rose
Hi Buddies,

This is keerti...Can u pls help me in this...."I am developing a report in General Ledger Module....I have to display "Today Closing balance has to be dispalyed as Tomorrows opening balance"....Pls do the needful...It's really helpful to me.

Posted: Sat Mar 08, 2008 2:48 pm
by admin
select sum(amount) from table where date < sysdate;

Posted: Sun Mar 09, 2008 12:42 pm
by keerti_rose
[quote]select sum(amount) from table where date < sysdate;

I don't think so