SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Extract - i want last 3 months

Accepted Solution Solved
Reply
Regular Contributor
Posts: 229
Accepted Solution

Extract - i want last 3 months

Hello,

I have an extract which looks like this to make a smaller subset:

Turn_Date > Today()-93

But what i really want is the current month + the last 3 months ( but the complete data, and not really 93 days )

Any tips, help? Is this possible in an extract?

Greets


Accepted Solutions
Solution
‎07-08-2011 05:30 AM
Regular Contributor
Posts: 229

Extract - i want last 3 months

and the answer is:

turn_Date >  intnx('month',today(),-3)-1;

View solution in original post


All Replies
Solution
‎07-08-2011 05:30 AM
Regular Contributor
Posts: 229

Extract - i want last 3 months

and the answer is:

turn_Date >  intnx('month',today(),-3)-1;

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 170 views
  • 0 likes
  • 1 in conversation