DATA Step, Macro, Functions and more

Need to filter with date range while extracting from Table

Reply
Contributor
Posts: 68

Need to filter with date range while extracting from Table

Hello,

 

I need to filter data as per the different date range requirements

 

The requirements are

 

1. The claims Loss Date between October 01 and oCTOBER 31 2017.

2. CLAIMS LAST UPDATED DATE between October 01 and oCTOBER 31 2017

3. Since we use the second condition there should be claims that have old loss dates , so I need only the Claims Loss date from 2015 January 01 with the Claims Last Updated date between October 01 and oCTOBER 31 2017

 

Please help me on this

 

Super User
Posts: 22,874

Re: Need to filter with date range while extracting from Table

Posted in reply to ambadi007
WHERE <condition1> AND <condition2> AND <condtiion3>;

I would start adding each condition one at a time and testing your process.
Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation