How to calculate Starting date of every month(Trail Balance)

building reports desktopintelligence
1

Hi all,

Is der a way to calculate starting date of every month with out any user promots?

i need to calculate ending balances of every month in a cross tab where

Ending balance= Begining balance of month+ Net transaction.

to calculate begining balance i need to pull the amount of the previous month ending balance(for jan its 0 but for feb : begining balance =ending balance (jan) + net transaction (feb) vice versa…)

Can anyone suggest me how to acheive dis?

Thanks in advance…

Cheers,
Nickie.

nickie :us: (BOB member since 2010-02-16)

2

Hi Nickie,

This will give every moth’s first date up to a year:

select trunc(sysdate,'MM') from dual
union
select add_months(trunc(sysdate,'MM'),-1) from dual
union
select add_months(trunc(sysdate,'MM'),-2) from dual
union
select add_months(trunc(sysdate,'MM'),-3) from dual
union
select add_months(trunc(sysdate,'MM'),-4) from dual
union
select add_months(trunc(sysdate,'MM'),-5) from dual
union
select add_months(trunc(sysdate,'MM'),-6) from dual
union
select add_months(trunc(sysdate,'MM'),-7) from dual
union
select add_months(trunc(sysdate,'MM'),-8) from dual
union
select add_months(trunc(sysdate,'MM'),-9) from dual
union
select add_months(trunc(sysdate,'MM'),-10) from dual
union
select add_months(trunc(sysdate,'MM'),-11) from dual

Rajubollas :india: (BOB member since 2009-09-04)