hi,
I'm using Crystal Reports 2008 with SQL 2005.
I have a table with some records containing startdate and enddate. What I need is the following:
I need to calculate how many days in a month an event occured.
like
"disk failure" from 01/02/09 to 10/02/09
disk failure - 10 days in February
but if I have:
"disk failure" from 21/04/09 to 05/05/09
I need:
disk failure - 10 days in april
disk failure - 5 days in may
Can Anyone help me?
Thanks
Daniel de Sousa