The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

identify "consecutive dates"

AbbasZavar22AbbasZavar22 Member Posts: 6 Learner I
in Help
I have patients' data set and I have to identify two "consecutive dates" of lab test results dates which are between 90-700 days.
Each patient has several lab test results, how can I compare all two dates together and find the consecutive dates?


Patient_ID                               Performed_date     TestResult
1.00100000023498E15       Thu May 28  2015 54.0
1.00100000023498E15       Thu Sep 26  2013 59.0
1.00100000023498E15        Tue Oct 28  2014 53.0
1.00100000023498E15        Wed May 06  2015    54.0
1.00100000023498E15        Tue May 05  2015 55.0
1.00100000023498E15        Fri May 01  2015 48.0
Sign In or Register to comment.