Counting Consecutive Dates or Gaps in dates

Posted by Hughes, John on Apr 04, 2007; 3:17pm
URL: http://spssx-discussion.165.s1.nabble.com/Counting-Consecutive-Dates-or-Gaps-in-dates-tp1074911.html

I have one record per client per month but some have stops and restarts.
I would like to count either how many gaps there are in service or the
number of months of service that are consecutive. Any help would be
appreciated!

 

John Hughes, Ph.D.

Director, Decision Support Services

Office of Early Learning

Agency for Workforce Innovation

107 East Madison Street

MSC 140

Tallahassee, FL 32399

850.921.3471 (Office)

850.414.2434 (Fax)

 

Please note: Florida has a very broad public records law.  Most written
communications to or from state officials regarding state business are
public records available to the public and media upon request.  Your
e-mail communications may therefore be subject to public disclosure.