Skip to Content
avatar image
Former Member

Report period first day to current date

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06 at 01:55 PM

    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’)

    Add comment
    10|10000 characters needed characters exceeded