YTD Formula-Custom Requirement

system · April 22, 2009, 10:45am

hi All
I have a requirement where i need to fetch data between
Start Date of First Year to Today’s Date
(i.e. from 01-01-2009 to 22-Apr-2009)
How can we achieve this?

I dont have any Calendar table in DB, i am working with Audit universe and would like to capture this information here

Env : BO XI R2

Regards
Nirav

nniravv (BOB member since 2007-08-16)

system · April 22, 2009, 3:04pm

Nirav,
What is the database platform?

Thanks,
John

jsanzone (BOB member since 2006-09-12)

system · April 29, 2009, 3:02pm

Its Oracle 10G

Regards
Nirav

nniravv (BOB member since 2007-08-16)

system · April 30, 2009, 7:51pm

you can use TRUNC(SysDate,‘YEAR’) “First Day” FROM Dual for the start of the year and getdate() or sysdate() for the current date

madhu kothamasu (BOB member since 2007-07-31)

system · April 30, 2009, 10:09pm

if you want to put it on filter the user Action date object from the Universe.

=Action_Date Between trunc(sysdate,‘yyyy’) and sysdate

Rj

rj_srnth (BOB member since 2006-12-09)