working with dates

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

I have a list of data that includes information such as; Name, Policy Number,
Original Effective Date, Status and Cancellation Date. There is other
information as well. I am trying to count how many policys I had active in
each month since January of 2003. So if a policy has an Orginal Effective
Date of 03/01/2003 and then was cancelled in 04/01/2005, that policy would
have a count of 1 for each month it was active. I need to show the
information in a grid something like this.

Jan Feb Mar etc.
2003 55 56 67
2004 70 66 42
2005 75 65 60

The problem I'm having is each row needs to be counted for each month it was
active. Not sure how to handle this. Hope this makes sense. Thanks for any
help you might be able to give me.
 
How are parital months to be handled. For example 15 jan 2003 thru 15 feb
2003??
 
Thanks for the quick response. I actually use cheater columns to pull out
the month and year. If it was active at all in the month I need to count it.
Thanks for your help.
 
Back
Top