Skip to Content
0
Former Member
Apr 29, 2009 at 06:05 AM

Break 1 record in 2

11 Views

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