Date LookUp
I have a list of policies that contains an Effective Date and a Cancellation
Date. I'm trying to do a count by month over the span of a couple of years
of how many policys were active in the given month.
For Example;
May 2007 = 423
June 2007 = 427 and so on.
I need to know if the month I am counting (May 2007) is between the
Effective Date and the Cancellation Date and if it is to include that line
item in the count (423).
Any help will be appreciated.
|