Comparing create and expiry dates

[#1]

Hi,

I have 2 date fields one create date and expiry date....

I want to compare these two dates in the chart side by side with their counts for every year.

can any one please help me in doing this.

[alexandros17]

Could you provide an example of comparison? What Do you want to know, number of days, of months or what else?

[alexandros17]

Here is an example, hope it helps but I wait other informations.

[#4]

When you have two dates, one for creation and other for expiration, usually it is a good idea to use a Triangulation Report. This consists on using a Pivot Chart, and putting one date on columns and the other on rows, and your measure (number of contracts, for example) as your expression for the cells value.

Bellow you have an example of this type of report:

JG