Count of difference in dates and %

I have a req where i have to compare two dates suppose A,B

if A is less THAN B ....count should be placed in a column

if A is greater THAN B ....count should be placed in ANOTHER column.

and based on the number of invoices it should give me the % of each A and B column.

Thanks

Imran.

Edited by: imranmoh123 on Jun 10, 2009 3:34 PM

Edited by: imranmoh123 on Jun 10, 2009 4:14 PM

Edited by: imranmoh123 on Jun 10, 2009 5:18 PM