Extracting start date of every year

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

Extracting start date of every year

 

 

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 .

 

 


Accepted Solutions
Solution
a week ago
Esteemed Advisor
Posts: 6,661

Re: Extracting start date of every year

Start of the year can be determined as

intnx('year',today(),0,'b')
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
a week ago
Esteemed Advisor
Posts: 6,661

Re: Extracting start date of every year

Start of the year can be determined as

intnx('year',today(),0,'b')
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Grand Advisor
Posts: 17,358

Re: Extracting start date of every year

where year(date) = year(date());
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 64 views
  • 2 likes
  • 3 in conversation