Hi
I'm looking for a way to return how many times a date occours until a specified date / within a specified date range.
i.e: Today is 06/04/2009, and my specified 'end' date is, say, 14/12/2011. I would like to work out how many times the 10th of the month occours between now and then, if that makes any sense?! The value I'd be looking for in this instance would be 32 (there are 8 more '10ths' left this year, 12 next, and 12 in 2011).
I realise I could just 'count' the number of months difference, but if for example the date I specified to search for was the 31st, it doesn't occour in all months etc etc.
Would be greatful if anyone could give me any pointers
I'm looking for a way to return how many times a date occours until a specified date / within a specified date range.
i.e: Today is 06/04/2009, and my specified 'end' date is, say, 14/12/2011. I would like to work out how many times the 10th of the month occours between now and then, if that makes any sense?! The value I'd be looking for in this instance would be 32 (there are 8 more '10ths' left this year, 12 next, and 12 in 2011).
I realise I could just 'count' the number of months difference, but if for example the date I specified to search for was the 31st, it doesn't occour in all months etc etc.
Would be greatful if anyone could give me any pointers