Extracting start date of every year

[Deepti44]

hi ,

I have a report which is productionized , i want to fetch the data from starting date of every year to till date.

Foe example : if i run the report today , it needs to see the start date of this year 2017 as  i.e 01jan2017 :

if i run the report next year it needs to fetch data from "01Jan2018" dynamically .

Is there any solution for this .

[Kurt_Bremser · Accepted solution]

Start of the year can be determined as

intnx('year',today(),0,'b')

[Reeza]

where year(date) = year(date());