BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Keeping the latest date when difference between two dates is 1 or 2 or 0
Keeping the latest date when difference between two dates is 1 or 2 or 0

Hi,

I want to retain the latest date when the difference between two BOD meeting dates is 1 or 2 or

Meeting_date	date_diff	Co_code
24-01-2012	94	11
22-05-2012	119	11
23-05-2012	1	11
09-08-2012	78	11
29-10-2012	81	11
01-11-2012	3	11

In the above instance, for example, when the date difference is 1, I want to drop 22/5/2012 and retain 23/05/2012.

Pls help me with the code for this.

Thanks

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Keeping the latest date when difference between two dates is 1 or 2 or 0
Keeping the latest date when difference between two dates is 1 or 2 or 0

0 Response to Keeping the latest date when difference between two dates is 1 or 2 or 0

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Keeping the latest date when difference between two dates is 1 or 2 or 0 Keeping the latest date when difference between two dates is 1 or 2 or 0

0 Response to Keeping the latest date when difference between two dates is 1 or 2 or 0