soldat452002
Registered User.
- Local time
- Today, 14:41
- Joined
- Dec 4, 2012
- Messages
- 50
Hello ,
I have some data that needs has two dates Date Effective and Date Expiration with a Producer ID (PK). I need a query to search the Producer ID and find date gaps between these two Date Fields (date Eff), (Date Exp).
Can someone guide me how to do this in a query? I have like 90,000 Records. Thanks
ProducerId Year DateEff DateExp
0000300063 2007 1/1/2007 12/31/2007
0000300063 2008 1/1/2008 12/31/2008
0000300063 2009 1/1/2009 12/31/2009
0000300063 2010 1/1/2010 12/31/2010
0000300063 2011 1/1/2011 12/31/2011
0000300063 2012 1/1/2012 12/31/2012
0000300063 2013 1/1/2013 12/31/2013
0000300063 2014 1/1/2014 12/31/2014
0000300063 2015 9/22/2015 12/31/2015
0000300063 2016 1/1/2016 1/1/2200
I have some data that needs has two dates Date Effective and Date Expiration with a Producer ID (PK). I need a query to search the Producer ID and find date gaps between these two Date Fields (date Eff), (Date Exp).
Can someone guide me how to do this in a query? I have like 90,000 Records. Thanks
ProducerId Year DateEff DateExp
0000300063 2007 1/1/2007 12/31/2007
0000300063 2008 1/1/2008 12/31/2008
0000300063 2009 1/1/2009 12/31/2009
0000300063 2010 1/1/2010 12/31/2010
0000300063 2011 1/1/2011 12/31/2011
0000300063 2012 1/1/2012 12/31/2012
0000300063 2013 1/1/2013 12/31/2013
0000300063 2014 1/1/2014 12/31/2014
0000300063 2015 9/22/2015 12/31/2015
0000300063 2016 1/1/2016 1/1/2200