cancel
Showing results for 
Search instead for 
Did you mean: 

Report period first day to current date

jacobsson_axel
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

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