first of the year

From: Shawn <spedwards_at_qwest.net>
Date: Tue, 6 Jan 2004 21:35:48 -0700
Message-ID: <W0MKb.195$Gw4.73589@news.uswest.net>

I have the below script. Every year we change the date (dpdate) in it manually so it reflects the beginning of the current year. I just haven't been able to figure it out. Any suggestions would be greatly appreciated.

select decode(pull_level,'G','UNWRAPPED','S','WRAPPED') x, ga_id,

        prov_company,sum(amount) gloss
from std_invopt,event,acctg_txn_acty
where acctg_txn_acty.ev_id = event.id

        and std_invopt.id = acctg_txn_acty.sdio_Id
        and trunc(dpdate) >= '01-JAN-04'

GROUP BY
decode(pull_level,'G','UNWRAPPED','S','WRAPPED'),ga_id,prov_company /

Thanks Received on Tue Jan 06 2004 - 22:35:48 CST