Skip to Content
0

Report period first day to current date

Mar 06 at 01:49 PM

24

avatar image
Former Member

Hello, what is a good way to have a report filter (universe level) that Always gives period from first day of the current year to todays date? I need this to work with Oracle-syntax.

Regards, Axel

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 06 at 01:55 PM
0

use this or check attached link for more details.

http://www.dagira.com/2007/09/25/dynamic-dates-part-iv-yearly-date-ranges/#more-27

Start of This Year

trunc(sysdate,’YYYY’)

Share
10 |10000 characters needed characters left characters exceeded